As you note, the first season of TNG was sonically different because Bob Justman wanted a rich, melodic underscore. When Justman left, Berman wanted the scores dialed back.
Yes, even Jones's early TNG scores were different from his later work. A while back, when I rewatched "The Naked Now" for the first time in years, I was struck by how much Ron Jones's score for the episode emulated the style of TOS music. It was recognizably Jonesian, but it was Jones doing a TOS music pastiche.
And of course "Code of Honor" was scored by TOS's most prolific composer, Fred Steiner. I remember reading something back in '87 or '88 saying that Steiner wasn't brought back for more than one episode because the decision had been made to go in a more "contemporary" musical direction -- meaning that decision had to come fairly early in the game. I guess it was a gradual transition from traditional/melodic to contemporary/melodic to contemporary/atmospheric.
Speaking of Dennis McCarthy... In the mid 90s, I was watching a failed pilot on ABC on Saturday night. I don't remember
anything about it, except for this. As I was watching it, I kept noticing the score. It was plucked on a guitar. And I said to myself, "This sounds like a Dennis McCarthy score." Sure enough, when the end credits rolled, the score
was by McCarthy. I couldn't have done that again if I'd
tried.
Heck, I can usually peg a McCarthy score within ten seconds. He has a very recognizable style. Also often-imitated in his heyday. When I first saw the
SeaQuest DSV pilot, I was convinced it was McCarthy doing the score until I saw John Debney's name in the credits. And when later Trek composers like David Bell and Paul Baillargeon started to show up, their early scores tended to sound like McCarthy pastiches.
I'm not one of these people that absolutely hates Berman, I do recognise that he did some great work on TNG and he did help set up DS9 so he wasn't all bad. But Ron Jones was the most popular composer on TNG and he was fired because he didn't want to tone down his music. Star Trek is an adventure series, it deserved a big score just like the original series had. Berman's decision is the first sign to me that he didn't fully "get" Star Trek or what the fans wanted from it.
There's no such thing as "what the fans want." Trek fans are as far from a monolithic group as you can get; there's nothing they universally agree on. What you're talking about is your own personal tastes, and those don't represent universal standards. Personally, I agree with you; rich melodic scores are better. But simple logic tells me that's far from a universal belief. If nobody liked atmospheric scores, then atmospheric scores wouldn't have become so dominant in TV and film. Obviously there are a lot of people who prefer them, or are at least indifferent.
If Berman hadn't given the majority of fans what they wanted, then the shows wouldn't have been as successful as they were and he wouldn't have stayed in charge as long as he did. Naturally he couldn't please all the people all the time, and naturally the longer one person stays in charge of anything, the more accumulated gripes people will have toward him. But the job of any TV producer is to try to satisfy the audience enough that they keep coming back for more, so he wouldn't have kept
Star Trek on the air for 18 years straight if he hadn't been satisfying the majority of the audience for the majority of that time. Granted, for the last 4-6 of those years, the audience was steadily eroding away, and ENT would've ended sooner, or might not even have been made, if not for the fact that Trek was the linchpin of the whole UPN network and they really couldn't afford to be without it. But it's just illogical to claim that Berman was somehow profoundly out of touch for the entirety of the decade-plus during which televised
Star Trek was wildly successful under his supervision.