The best cycling training purchase that I have ever made was the CycleOps Electronic + trainer. I had seen it recommended several times by coaches, but always stayed away because of the cost. It has an incredibly road-like feel to it, and comes with standard courses and training routines like intervals, climbs and fitness tests. With a PC hook up I can use the Netathlon courses and join live internet rides, which has been a lot of fun and definitely helped pass the time on the trainer. I haven't even come close to being bored on it yet.
The mag trainer is just slightly louder than fluid, but I have not been able to kill it either. I have blown the seals on two fluid trainers and won't try them again.
Hope this helps. Good luck!