I've had a CycleOps Fluid2 Trainer for a couple years in which I used at least an hour 5 times out of the week during the off season and never had a problem.
yes its quiet but I didnt buy it for the silent spinning it gives me. The Fluid gives you progressive resistance. Because of the fluid, the longer and harder you pedal, the heat causes the fluid to expand which creates more resistance. Mag trainers are ok, but they peak out in resistance, even with an adjustable resistance which gives you maybe two types of resistance.
Also, if you want another option for training, try rollers. A bit harder to get used to but the training is much better. Helps you dial in you're pedal stroke a bit better since you have to concentrate to stay balanced on the rollers.
So trust me, the fluid2 is a great trainer, has never leaked on me before, and the ride quality is closer to road than anything I've ever ridden. And having the progressive resistance is a major bonus over mags.