Usually, no, especially with DS9 (Even that crappy spread-up version with the cheap drum track tacked on top used after season 4.)
However, as I was watching Prodigy on my desktop, my behavior varied. For a while, I watched the whole intro, but my anticipation became too much and I began skipping right through it as I got through season 2.