I have to turn up the TV sound when I'm on my Kurt fluid trainer, but it's not "too" loud, maybe "window air conditioner fan noise" loud. There's some low pitched noise/vibration from the tire not being perfectly round. I haven't tried it, but setting the trainer on a plywood base with a foam or carpet sheet underneath would help keep the lower sounds from vibrating through the house structure.

Fluid trainers are nice, they are fairly quiet, and the resistance goes up (and up!) as you pedal faster (and faster!) It's stirring some silicone fluid inside the trainer. A fan trainer has a similar resistance mode, but those are noisier.

Magnetic trainers usually have some kind of a resistance level dial, and are also quiet. But it's not quite as simple to manage the resistance if you want to go at a faster sprint speed and then do an easier pace. They are less expensive, though.