To be completely fair to Rick Berman, I recall he mentioned these very concerns himself in an interview circa 1999-ish (around the time of INS). He basically said he feared "going to the well once too often and finding there isn't any water left". But he was on staff at Paramount, and essentially had to do what Paramount told him. Which was make more Star Trek. So yes, Trek did
ultimately end up going to the well too many times. I've always felt Berman himself wasn't too keen on it by the end but he was just doing what he was told.