You get Eevee a fair bit earlier than you get a Super Rod so I'd say Vaporeon should at least get a bit more credit since its stats are fairly high compared to the other obtainable Water types. You can always just hold on to the Water Pulse TM from Misty until you evolve Eevee. On top of this, it also gets Bite and Aurora Beam fairly soon after you get it for some nice coverage. Of course, statwise Starmie is the infinitely superior option by virtue of stats and movepool alone, but for anyone interested in using an Eevee I'd debate Vaporeon to be one of the better choices.
Also Shadow Ball is garbage on Vaporeon because it's physical in this generation. Yeah, I'm not arguing how atrocious its TM learnset is.