Personally, I have never used a "turbine" sprayer, but from reading this is what I''ve gathered:
The advantages of hvlp over conventional air spray is basically spraying with less pressure coming out of the gun gives you less overspray rusulting in less waste and less mess. The disadvantage is that with less pressure coming out of the gun there is less atomization of the paint rusulting in not as smooth a finish, leaving you more work after applying the paint to achieve that smooth finish.
The main advantage of the turbine system is compactness and portability along with lower initial cost and you still get the hvlp advantages. However, the turbine systems are rated on the airflow that they can produce. The lower the airflow rating will produce even less atomization resulting in a less smooth finish. Needless to say, the higher the airflow the unit can produce, the more it costs. Mostly the lower rated units are used for painting things where the smootness of the finish is not a big factor (houses, walls, fences, etc.)
Here is another good video explaning the airflow ratings....
https://www.youtube.com/watch?v=IfGzCjRO_ZY
Another point is that you are buying a unit that is only used for painting. With a compressor at least you can do other things. My
