For me, it the theme song from The Munsters!

https://www.youtube.com/watch?v=JdrbLvFJkB4

And then of course there is this... I've never actually seen the show, but it was a kid's tv show televised in the UK that Brian May's (Queen) son used to watch.

Well, years later May called up his pals EVH, Alan Gratzer, Phil Chen and I believe Fred Mandel and this is the result. Starfleet!

https://www.youtube.com/watch?v=5lC54X5Gc1Q