You are either young or have lived your life in a dystopian movie. :)
Friends and Frazier are accurate portrayals of how cafe culture used to be. People used to go to coffee shops for hours, drink coffee and other stuff and just shoot the breeze. It was pretty great, and in a lot of ways better than a bar. The one by me growing up had a big leather couch in front of a fireplace that we liked to sit at, and it was pretty great in the Ohio winters.
In the DC area we have a big Ethiopian community. Ethiopians are big into coffee and coffee shops. If you go to a Ethiopian coffee shop, it's still like that. Some of the higher-end coffee shops that have sprung up in the area are also like that. We live by one that we often go to as a family every Saturday morning and get coffee and breakfast and just chat.
I have found the chain coffee shops have been taken over more and more by people camping out on laptops. It probably also depends on how much your area has actually coworking spaces.
I have also found that if a place offers more of a true cafe menu, you'll find more people talking. If a place can be something where you would realistically get lunch and coffee, it's much more likely to be lively. And for me, I'd rather be in a lively place regardless if I were there for lunch or if I wanted to work on my laptop a bit.