I could only remember the opening as well. It always reminded me of the old HBO intro to movies, where it had that beat that kept getting faster and faster, as the camera flew through the little neighborhood, eventually going off into space, revealing the HBO logo and just blasting music.
Here it is:
I've always loved that intro, and it was great to see it used similarly in Beetlejuice and The Burbs'