> So you would end up in whatever team lead decided that its best.
That's poor leadership on their part.
> Well if the rest of the team, is in their own offices and you are alone or with people from other groups/teams how exactly will that work for you, you might as well be in coffee shop across the street.
If the rest of the team is in their own offices, sure. That hasn't been the case for most teams I've worked on, however (which may be self-selection on my part--but it's never been hard for me to find a team I work well with).
> I am not trying to say that you should like individual offices, but you can't really mix both of them together, unless your teams are huge (which I personally dislike).
1. What's huge to you? The only team I've worked with which had a really mixed open/private space ranged from 6-10 people while I was there. There were 2-3 people who worked consistently together (let's call these extroverts, which includes me), 3-5 who worked consistently on their own (let's call these introverts) and 1-2 who floated back and forth (let's call these ambiverts). The shared space was mixed with other teams--it's also worth noting that even if the people around you aren't on your team, there still needs to be some collaboration between teams, so even if you're the only extrovert on your team, working in a shared space that still isn't the same as working in a coffee shop across the street. A team of 10 is starting to get a bit bigger than I like personally, but 6-8 feels pretty ideal to me.
Now I work for myself and I'm not seated with my client's team at all. But I tend to work in coworking spaces[1] frequented by other people working in my field, with people who frequently bounce designs and coding questions off of each other. This is a lot like your coffee shop idea, so that has some validity. But it isn't super ideal for me--if I continue getting consistent business, I may hire some people just to have some more direct collaboration in my life.
2. There also doesn't need to be this kind of diversity in the same team. You can have a team that's all introverts, or a team that's all extroverts, and in those cases, picking a completely private layout or a completely open layout, respectively, is fine. The point is to assess the needs of your team and build your workspace around their needs instead of looking for a one-size-fits all solution for some "normal" team that doesn't exist.
I'll note that it's harder to integrate one extrovert into a team with a lot of introverts than the opposite. I don't really have a good solution for that problem.
[1] Not WeWork. They're so expensive and overcrowded! Just because I am an extrovert doesn't mean I want to be sitting on top of my neighbor.