Millennium
La Femme Nikita
Highlander (not technically a theme song, since it's just a Queen song, but I like it)
Farscape (because the part they run at the end is funny, with that woman wailing in the background)
I like my theme songs eerie and brooding.