Product choice is paramount here. As Jeff posted above, the advice from Homestead finishing site is exactly right; 'wall paint' should not be used on furniture - it is too soft and 'blocks' (sticks to things placed on it). An enamel (harder finish) paint should be used. Many here have recommended SW Pro Classic (I heard about this product on NCWW first and consistently), but Benjamin Moore and others likely have comparable products (?). Buy the right product and you won't sorry.
Tintable water based lacquers are also suitable finishes for furniture, although you did not state specifically that those were the projects in your future. Tinted lacquers (choose the color like you do a paint) are available from Target, maybe directly, but certainly from dealers; note that dealers are few and far between and so this likely still requires shipping. Other brands may be suitable as well.
FYI - I started the spray finishing journey in order to 'up my game' in finishing, previously a weak point. I posted earlier about NCWW workshop at Phil's that enabled me to start. I have definitely improved -not without a few hiccups in refinishing furniture for other people. I am trying to follow the advice of 'picking 1-3 types finishes and mastering those', rather than having a different finish on every project. My choice is to use waterborne products entirely (and SealCoat shellac in alcohol). Target has been my choice of vendors and I have not been disappointed with the results. No connection to the company, and I am certain that other vendor products are recommended as well. I know Klingspor's carries General Finishes products, and that several here on NCWW use these (both solvent borne and water borne products).