Enterprise's premise sounded great on paper. Pre-TOS, more limits, no familiar races, no transporters, no phasers, blablabla. And what did we get? A KLINGON in the first 5 minutes of the show, a Vulcan Seven-of-Nine, phase pistols, and Archer getting BEAMED out to safety in the last 5 minutes. Woo-fucking-hoo. How different.
But, again, both Berman and Braga have stated that a lot of that was forced on them by the studios, to make it more recognizable.
As true as that is, Berman and Braga still mishandled things with Enterprise. Studio-mandated or not, the TCW was what the pilot episode was essentially about and should have gotten more attention throughout the series than it got. Instead, there's only a handful of episodes and in the end nothing is resolved.
At least with Enterprise's first season it seemed as though some effort was being put into the show. The TCW was featured in something like four episodes and we had a couple developing a conflict between the Vulcans and Andorians. Unfortunately that all gets essentially ignored in the second, with the TCW and Vulcan/Andorian stories each only getting one episode and the rest of the season was meaningless standalones until the finale introduced the Xindi, and that was another story mandated by the studio.
I normally say that Berman and Braga are unfairly vilified by fandom, and for the most part I do believe that. However, Enterprise is a show they really dropped the ball on and it can't be a coincidence that the best season is the one where they handed the reins over to another writer.
And no, I don't think another 24th century show would have done better. As much as Berman's "franchise fatigue" comment upset fandom, there is truth to it. Star Trek had been running continuously for nearly 20 years on TV and in movies. It needed a rest. Berman and Braga have since said that if Enterprise had the kind of writing in the first two seasons that it did in the last two it might have done better, but I don't know. The last season in particular only really appealed to hardcore Trek fans, and I really don't see the ratings being any different for Enterprise's early seasons had the been handled likewise.