There are some good recent turbo reviews on Youtube. Some turbos can make considerable noise. In the end we went all out and bought the Tacx Neo 2T. We chose it because it is direct drive, beltless, good heavy flywheel, whisper quiet, can work without a power supply as it self powers all functions from the flywheel (except for downhill decent mode). One feature is switchable, but it even manages to replicate different types of road surface - so if you are a cobbles specialist say, this might be for you.
It folds away easily though a bit heavy, it's not backbreaking. We bought a skate from Aldi for £10 from which is perfect for wheeling it around on. It connects via bluetooth with no fuss whatsoever. One downside was the cost, especially as you don't get a cassette with it, though you do get everything else including various adaptors for the range of axle and skewer types. You'll also need to buy a heart rate monitor if you don't already have one.
Tacx provided basic free access to their on-line training programmes for both of us. I'm happy enough to use this myself, whereas my other half chooses to subsribe to Zwift.
It is a truly brilliant piece of kit though and heartily recommended by us (FWIW).
Have fun in the pain cave! We can attest to the statements about the sweat though, our 12 inch desk fan falls way short of the job, and will be upgraded shortly.
Addendum: I should have mentioned that it self-calibrates so no phaffing about on that front either.