But great music enhances a show. I'm thinking of Game of Thrones, some True Blood themes and of course NuBSG. Not everything can be NuBSG but I do think the VOY and DS9 music was forgettable and occasionally awful. That's why we notice the music in Counterpoint, because it's real music and not just bombastic or waffley filler.
ENT had a much better score, noticeably atmospheric and creative. Not amazing, but amazing compared to the three series that proceeded it.