Air and magnetic trainers can make a bit of noise. Fluid trainers are very quiet. My new rollers are nearly completely silent. I have an air trainer and the new rollers. They are both clean. I also have an "exercise equipment" mat that I put the trainer on. Its basically a big rubber mat.
The rollers do require you to balance. I don't consider my balance all that great. Rollers will make you a better cyclist by improving your balance. I find it a much more interesting experience than being on the trainer. I still ride the rollers in a doorway or in the hallway just in case. I have crashed a few times on the rollers. No damage except my ego in this admission. 30 minutes on the rollers and my quads are burning! It is a very good workout!
Hope this helps.
So, anyone interested in what I call, "Trainer Wars" this winter?