I've got
CycleOps' entry level one. Not sure of the model #, but it serves it's purpose. They make a solid product.
I can cut down on the noise level if the surface underneath me is solid such as a concrete slab. If I ride on the second floor of the house it gets loud.
The only thing I don't like is after a while it gets
boring as all hell. One cure for that is to throw on a
Spinervals DVD and train along with it.
If I do have no other choice but to ride indoors I usually opt to get on the rollers instead of the stationary trainer. It's more of a challenge since you really have to concentrate on what you're doing as opposed to mindlessly hammering away on the trainer(not that there's anything wrong with that). Rollers have the added benefit of developing solid bike handling skills and teach you how to ride straight. I can now ride the white stripe on the side of the road for miles without coming off.
Mine are from
Minoura and decent for as often as I use them.
Kreitler is considered the Rolls-Royce of rollers.