Personally I'm bored to tears by both DS9 and V'ger's lethargic, self-important orchestrations. DS9's visuals are dull and repetitive. V'ger's visuals are nice but full of scientific flaws (that ice ring would have to be perfectly smooth and nearly solid to reflect the ship).
TNG's opening is, IMHO, the nicest, the original showing a symbolic cruise outward through our own solar system and into interstellar space, all in one very clever, unbroken take. Then they ruin it by blasting that damn, bombastic nautical theme stolen from TMP. TNG basically doesn't have its own theme, it uses the TOS theme to start, then the TMP theme to finish. But the visuals are nice.
I still don't think anybody has beaten the original, though. I nice simple bosanova with the credits flashing by.
The less said about the Enterprise opening the better. OY!
Just one man's opinion.