Any recommendations for a good indoor turbo trainer?

I managed to get fitter the other year by spinning etc but my own trainer is lousy, it's noisy & doesn't feel anything like real riding.
I am after a trainer that will accommodate 26" to 700c wheels, is quiet & gives a realistic load rather than a simple brake type resistance that stops the wheel dead as soon as the pedalling effort is reduced.

I'd rather be in the hills but distance & time is prohibitive.

Any advice welcome, cheers.