The same rule for microwave cooking applies to spray painting: it does the job faster, not necessarily better. If you don't use the right equipment or technique, the results can be an inedible meal or a paint-covered mess.
Pros and cons
Sprayers apply an even coat of paint without leaving brush marks or drips. They can also cover large areas faster than a brush. For small projects and detail, a brush offers more control. A spray can is also an option: it's cheaper, minimises cleanup and can be recycled when empty.
Types of sprayers
A variety of sprayers are available, depending on the paint thickness, price and other factors. Stick to those that use air to atomise the paint and leave the airless sprayers to the professionals.
Best for Furniture
For furniture, This Old House recommends (from least to most expensive): cup guns--for small painting jobs; air-compressor guns--produce a smooth finish but oversprays, so use a spray booth; and high-volume/low-pressure guns--little overspray and very smooth finish, for trim, cabinets, mouldings and doors.