You'lll get dozens of different answers to this question.
Go out to your local supermarket and try different brands/types every week.
You'll find your favourite.
I personally only drink soy milk as I can't digest milk or even lactose-free milk.
However I have tried many different cow's milk for my sister.
I'd say my favourite cow's milk for frothing is Devondale Barista's Milk.