There's really no real rule as to which paints are better. In truth, it's personal preference. Just remember that some thinners contained in some types of paint can eat through the surface of paint layers already on a model.
Water basec acrylics can be damaged by some enamels and Automotive acrylics and enamels can be damaged by automotive acrylics.
There are many paint manufacturers that make very good products. Many of us are limited to the paints sold by the local hobby shop - they can't stock every color of every brand of paint, can they?
Generally, go for a good enamel (Model Master and Xtra-Color make good paint) and for water based acrylics, Tamiya, Gunze Sangyo are both very good (apologies to the other manufacturers that make fine paints but my local hobby shop doesn't stock).
An Airbrush is probably the one tool you can have that will make the largest difference to the quality of the finished product. If you don't have one, go and get one and learn to use it. Kalmbach sell very good books on how to airbrush, and FSM often has how-to articles.
Cheers
LeeTree