I was initially astonished at their choice of an intro song. As the seasons proceeded it became an integral part of the watching ritual. It was a time our family set. a side other stuff to sit on the couch and watch. It may seem cheesy but it was almost as important as mealtimes together, and happened much less often!
When I pop the DVDs into the player I make a point of playing the intro every time for the nostalgia.
Never loved the song for it's own merits (didn't hate it either - kind of a meh song) but am very attached to it because of the nostalgia factor and it's assoc with the franchise