HVLP spray guns can be turbine or compressor. Both can offer similar transfer efficiency.
The benefit of turbines are that they are a complete set up and are portable. Earlex, Bambi (apollo), Fuji, Graco all make a range of turbine systems. I think the spray guns for these systems are mostly pressurised cups sitting under the gun. This makes them balanced for spraying but the cup can get in the way. Also the tube is quite thick and may feel cumbersome. The turbine warms the air which can result in orange peel with some solvent based lacquers.
Conventional HVLP guns, such as a SATA 1000B, need quite a large compressor. Similar transfer efficiency to turbine, air pressure requirement is about 2.5 to 3 bar (from memory!). This particular gun can be set up with tip sizes from 1.0 to 5.0 for a very wide range of materials. I would guess a tip size of 1.6 for clear furniture lacquer and maybe a tip of 2.0 for external water based joinery paints.
If you want to do a lot of spraying or finish large items a cup gun will become frustrating and a pressurised system, conventional or air assisted airless.
I find spraydirect helpful, they supply the joinery and cabinetmaking trades so will be able to offer advise on merits of different systems.
When it comes to spraying, in most cases you will need to thin the material for a good finish.