Fascinating question. My mother ran a day care from our home, so almost certainly above what is the norm, though i wouldn't describe it as particularly noisy/rambunctious.
I grew up as an only child on a fairly pastoral 15 acres, so very different environment compared to most people who have siblings. As an adult, office noise bothers me a lot more than most, especially conversations.
The idea of being productive in a cafe / starbucks is almost absurd to me, like a Monty Python sketch. Although, I sort of feel the same about Open Office plans, which is less funny, especially in the Bay Area.