He's literally the best to have in every single region except bw where he's not in the game.
Gamefreak gives you access to magikarp in most games before the first gym.

Hell if you don't even feel like training him you can toss him in a daycare before the 3rd badge and cycle around for 5 mins.

Why the fuck shouldn't you use him?