I think the decision to have the two continuation series set in the contemporary for TNG was the wrong move. Unfortunately, DS9 had already started by that time and was running concurrently with TNG.
After TNG ended, and we go to the film-era, Voyager should have been set in the 25th Century.
Enterprise was a bomb primarily because we had just watched 21 seasons of the 24th Century, with its rich history and full of characters, and we had already had TOS with 3 seasons of the 23rd century, none of which reference the fact that a ship named NX-01 Enterprise ever existed. It was doomed from the start.
I thought Enterprise was a bomb because the writing was terrible for the first 2 1/3 seasons.