TNG and DS9-wise, yep, but I wouldn't necessarily credit that to Berman.
Well, you should because he still produced both and co-created DS9.
None of us are professionals within the industry to say how he is viewed within it. The reasons why he isn't working are only known to him. Dealing with Paramount and zealous Trek fans, I wouldn't be surprised if the man had a nervous breakdown.