Are there many comic book shops? - Yes.
Are there enough comic book shops? - No!
I know of about 10 in Toronto alone, ranging from tiny shops to large stores. In my experience that's about normal for a large North American city. So yes, I think there are many.
And I think a lot are like what you see on The Big Bang Theory - they are unusual places where you can find interesting people.