I use a CycleOps Magneto and my DH uses a CycleOps Fluid trainer, both about 3 years old. They are both very quiet, with a smooth ride, and easy to use.

We have heard good things about the 1Up trainer and would consider getting one of these in the future.
http://www.1upusa.com/bike_trainer.html
Blackburn has a similar model called the Trackstand ULtra.
http://www.trakstandultra.com/