I have only played FireRed and Emerald, so my answer will be very limited. However, I will do my best!
As a general rule, use the regional birds early-game, as they are easy to get and quite reliable if you keep it up in levels. Also do not abandon your starter. I will include the objectively best starter in my list, as they are technically early-game. I will not include remakes separate to the original game because a lot of it is the same. I may include a few things, though.
For Red/Blue/Yellow, your starter should be Bulbasaur. It is the best starter in this generation with a good supportive movepool(type wise, that is). Spearow is just better than Pidgey in early as well as late game, so it is a good option. Butterfree also has some good early-game stats as well. Definitely get Nidoran Male as your ground type(early-game Nidoking is a monster). For the gen 3 remakes, get Abra.
For Gold/Silver/Crystal, you should use Cyndaquil. Definately get the Machop for Whitney(or else you pretty much can't win). This time around, use Spearow instead of Hoothoot. Noctowl has one of the worst gen 2 movepools to exist with its stats, literally its only level-up special move that's not dream eater(too unreliable) is confusion.
For Ruby/Sapphire/Emerald, your starter should be Mudkip. It has the best typing, as there is no grass gym(which its its only weakness). Get a Ralts ASAP as well, do not care about that 2% spawn chance, just get it. Dustox has a good movepool as well. Sableye for 2nd gym if you are playing Emerald, as Brawly cannot hit ghost types! In the remakes, nothing changes except for Gallade existing which is basically still Ralts.
For Diamond/Pearl/Platinum, get Chimchar as your starter for good typing and decent coverage. Starly is actually good this time around, so get it. Roselia to make the first gym easier I guess??? Never played gen 4 so don't really know.
For Black/White, get Drillbur I guess? The regional bird(Pidove) isn't THAT bad either. It's useable... Get Oshuwat as your starter because it has a good movepool as well as the ability to destroy the efour(elite four). Tepig is better for a more casual run, in my opinion.
For X/Y, Froakie and Fennekin is basically the same problem as Oshuwat and Tepig. Greninja crushes the efour, while Delphox has a better advantage against most gyms. Vivilon is a good support(powder moves), and the regional bird is a very good choice if you picked Froakie as your starter.
In Sun/Moon, get Poplio. You may not like it, but you asked for the list of good Pokemon... anyways, Poplio actually counters all four island Kahunas(fairy takes dark and fighting, water takes rock and ground). You may say that you can't get fairy type until Primarina, but Poplio is still the best option. The regional bird(Pikkipeck) has a good attack stat as well.
Lastly, get Scorebunny for Sword/Shield. Scorebunny is a bit better in Shield than in Sword, as it can easily sweep Melony's team(Lapras excluded). Rockedee is probably the best regional bird to exist, in my opinion. Corviknight is just too good. You get flying. steel, and numerous fighting moves as well. Lastly, Rolycoly's final evolution Coalossol can eat Leon's Charzaird's moves for breakfast, especially when dmaxed.
Hope I helped!
*Sorry for misspelled Pokemon!
