All the composers for Star Trek have been incredible in their own right. Everyone has their preferred (James Horner) but I have yet to not enjoy a Star Trek opening. And yes, that includes Enterprise. It tried to break the mold and failed, but I give it a pass because the visual sequence with it gets me still.
I will say that First Contact's theme is damn good. Especially when used at the end with the Vulcan meeting.