Yes, we bought a spin bike for our place.
Like you, we found the indoor trainer set-up very noisy (the only plausible place indoors is in the living room/area)
Plus, having an indoor trainer meant alot of bike-swapping as there is a big discrepancy in height/size between the cyclists in this house (5'10" - 6'4").
So having the spin bike has solved both problems. It is a heckuva lot quieter... whoever is on the spin bike (unless they are doing high cadence work) does not interfere with tv or stereo and can hear what is going on too.
It does have a knob to adjust resistence. It has its own little comp on it that does speed, distance, heart rate etc, but we have an extra one on there set up to the pedals so we can measure cadence.
I do cadence training on it (great, cause its just like a fixed gear bike of course), as well as "aerobic time trials" and sometimes standing. Mostly it gets used by all of us to warm up or cool down, or do a recovery ride.
We bought it from torpedo7.co.nz
Looking at it now, it has no brand name on it, so I can't remember the make/model etc - but its pretty generic... I assume like the ones you have been using at the gym.
In my opinion, and I think the rest of the family here that uses it, it is a much better option than having a trainer indoors.
Courage does not always roar. Sometimes, it is the quiet voice at the end of the day saying,
"I will try again tomorrow".