Kurt Kinetic road machine is a good one around that price range. Runs fairly quiet and smooth. The fluid resistance feels more natural than magnetic units and the magnetic coupling means it is less likely to leak fluid than one with a shaft.

But when it comes down to actually riding even a good trainer, given a choice between riding the trainer and visiting the dentist, I would have to think about it for a while.