I haven’t tried them (and I cannot ride a bike) but they seem great and not super loud. There are lots of sound test videos for them, so if you’re leaning toward a model just search for that one:
Based on what I’ve seen anecdotally (one of my friends worked for Zwift and used it a lot, a few of my extended family members use it or Peloton) and the huge communities around it, it’s great biking practice when you’re stuck at home with the resistance adjusting to simulate going up hills, and if you’re going to have your bike stored in your apartment anyway it doesn’t take up any extra space.