I think that is for people who do not want any noise like at all. Like, thats if you are the person who doesn't really wanna socialise, more internal, happy to sit in bed all day without socialising. Bare in mind as well, if you picked this, it would probably a really big disturbance if you had a lot of friends round or came back drunk and made noise sometimes.
Most people are nice, tend to be respectful. Specially when asked! Drunk people are sometimes crazily receptive, if you tell them to please shut up because its late and you have a 9 am, they will probably sulk back to their rooms. I'd say 50% of people are like that, you will get put would loud people who wanna drink every night and will make noise every night theres any sort of promotion at a club if you say you wanna be with people like that. I think its also more likely to happen in Rootes because it does have that connotation always (but there are still quiet blocks in Rootes.
Mostly though, people make noise one or twice a week, and if you plan on going out occasionally, sometimes it will be you making the noise! Its just about being mindful, respecting you're flatmates and hopefully as long as they aren't horrible people, they will respect you back.
If you don't go to these quiet areas, will you get waken up? Yeah probably, maybe once or twice a year. But, thats all in the fun of it. Issues arise when there is absolutely fundamental mismatches, quiet people in a loud house. I've only know like 2 people who have flatmates like that. If you do want to socialise, i think you'll have a harder time doing it in a quiet area. As long as you emphasise that you expect people to respect your sleep but you want to be with people who are happy to chat or go out on a saturday night, then just go for normal