I have been to Cleveland three times so I cannot be swayed by this (NSFW sound) promotional video:
This is equally, uh, compelling and makes a good point at the end:
Now this makes me want to visit Cleveland just a bit more:
In terms of openings, though, nothing tops this:
I remember seeing that and thinking it weas the most amazing opening credits sequence I had seen on TV, but what followed was kind of disappointing, although it picked up in later seasons and I really liked "Whose Line Is It, Anyway?"