My shack is in the basement of our ~1600 square foot ranch. 3 bedrooms upstairs, 2 kids. Noise etc made me choose the basement when I got back in to radio. At bottom of stair, so can yell up and down, and semi be part of the family. My wife is okay with it, would not be okay with it being front and center of our living space.
I have a neighbor who is a ham, when I went to visit he has his IC 7000 in the living room, next to the couch. His wife sits next to it and reads and knits, they can both watch TV. He has a headset with mic and key right there. They are in their 60's and kids are gone.
I met another guy because someone asked me to stop by an help with his antenna. He has a $3000 HF rig, and $400 antenna, and neither is up and running because his wife wanted the attic space for herself, in the bump out for a window that I bet is less than 8x10. No kids at home, in their 50-60s.
My point: I think it depends on relationships. If I wanted it in the living room, my wife would say okay within some limits because it was important to me. Its not, so I am quite please in the basement, semi connected when playing radio.
My woodshop was in a detached garage because I did not want to be disturbed burning scraps of wood in the stove and napping in my chair. Learned it from my uncle - his wife still wonders why the intercom system to the pole bard never got connected, and why he still accidentally leaves his cell phone in the house whenever he goes to the pole barn for man time (light wrenching, or woodworking, or hunting equipment maintenance). Its uncanny!