I use a magnetic wind trainer, pisses the mrs right off if she watching one of her telly shows. It tends to whine, three time worse if i use the mtb on it with nobblys, nobbies, nobblies (how ever I am meant to spell it).
If I was a man of infinite funds, I lash out buy a recumbent exercise bike, extremely quiet, a variety of built in programs to amuse one's self with, very comfortable to sit on for an hour or two... I really struggle with more than 30-45 mins on the road bike when it's on the wind trainer, the lack of body movement and the somewhat 'aggressive' posture make it unpleasant on the arse hands, neck and shoulders, strangely I don't get this when I am actually out road riding.
Unless you're elite level, I don't think it would make much difference quality wise whether you exercised on a exercise bike, wind trainer or rollers, the two later are obviously more specific posture wise, but if you are still riding you bike on weekends it'll all transfer across no problems.
I'd also highlight that the wind trainer has been really good for developing a nice candence, but buy a fan too, you'll sweat like a pig otherwise.
pedaling whilst rotorburning... if only it was an mtb.