I can vouch for the Kurt Kinetic Road Machine. It's quiet enough, smooth as silk and pretty good at replicating road feel at the pedals. I still enjoy my Kreitler rollers for proof of fit and position on the bike and for having to at least be aware that I'm still alive and breathing on a bike while inside. They do take focus and form if nothing else.
AS RDO said, trainers are efficient, are a really good use of training time, can do almost anything a road ride can in terms of effort and if you spend enough money on the distractions (music, fans, virtual reality, smart trainer, etc.) they can even be fun. Or so I'm told!
I'm more like dabac in thinking indoor riding on a basic trainer is just mind numbingly boring. A great workout, but hard to get through on an everyday basis...also sometimes known as an Ohio Winter! Unlike Swampy, doing intervals does zero for my ability to tolerate sitting inside on a trainer other than put high stress levels on the frame of the bike perhaps. I totally agree that a trainer should sit in an unheated garage, basement, storage shed or anywhere cold and remote where people won't hear me scream when I go mad from the boredom.
Note to self: Get a Zwift subscription.