Paint for furniture?
There are many companies that sell; pigmented lacquer, pigmented conversion varnish, and pigmented polyurethanes; when you want solid color furniture coating. These are not available at local big box store, and require a trip to your local industrial/commercial wood finishing supplier.
Not all brands have distributors in every city; which means it is difficult recommend ONE brand. There is a lot of similarity between brands, making any almost brand manageable to use.
For solvent based pigmented/tinted top coat, look for: Sherwin Williams, ML Campbell, Benjamin Moore Lemar wood coatings, Lorchem, Mohawk, Sikkens, or Chemcraft (in random order).
Acrylic modified lacquers are most popular due clarity, flexibility, and ease of application. If you need a durable coating for bath cabinets or table top, then likely want a 2 part conversion varnish. If you need the most durable 'bar top' finish, 2 part polyurethanes are common recommendation.
Water based finishes can be more challenging to locate as they are relatively new (compared to SW conv varnish used as an industry standard for over 2 decades). Beyond the companies mentioned above, can also get WB top coats from; General Finishes, Target Coatings, Renner, Milesi, and IC&S-ILVA.
Water based top coats have been inferior to solvent based coatings in past; as they all use 'softer' acrylic polymer instead of harder resins found in solvent coatings. The newest WB 2K polyurethanes from several Italian mfg (last 3 in WB list) are some the most durable finishes in market, even when compared to gold standard solvent based 2K conversion varnish. Just like a solvent based top coat, the most durable WB coating will be a 2 part system.
IMHO - Instead of asking random forum for wood finish recommendations, suggest you ask your local professional finish supplier. They will work with you to ensure success, just like they do with any other furniture maker in the area.
There are a lot of existing finish top coat threads on LJ.
Can search for the mfg names listed above to find them more quickly, and to help you learn more.
As always with finish recommendations, YMMV.
PS - None the the above are automotive paints. The automotive finish distributors and products are completely different, even if a company above sells into both markets.