These kind of stores definitely used to be more common in the 80s and 90s, IME, but I guess some are still around. Where the store exists to some extent as a clubhouse for the owner and his friends and employees, and doesn't make a really good effort to be customer-friendly.
It's been an interesting thing, over the years, seeing this stereotype gaming store gradually be replaced, IME, by friendly, clean, well-lit, professionally-run shops.
That has been my experience, as well. The Simpsons "comic book guy" type of store is a lot less common than it used to be, at least in my area. I saw a lot more of that in the 70s and 80s than in recent years. I suspect that a lot of them went out of business once online sales became more common, because nobody likes dealing with an unpleasant, unprofessional store owner (or employee). I still encounter some store owners who just aren't very good at running a business, but I haven't encountered one who was unpleasant to be around in quite some time.