Why technology has become problem in Berman's Star Trek story?
The answer is because The regular casts can't die. They have a very thick plot shield. This reason alone limit how the writers make suspense. as They have to 'save' those characters from their demise in every episodes. Thus the writers were forced to create magical technology just to save the day.
The example of this is what have we saw in Voyager. Where Paris and Captain Janeaway tried a warp 10 ship, but they were evolve into another creature. The story was funny. But guess what. The doctor can save both of them easily, and both of the characters return to human at the end of the day. Just imagine, a holographic doctor in a ship medbay can easily revert two characters from evolve to the next human evolution.
I think in order to prevent the technology from become overwhelming is by making the capability of the ship limited. For example, if some characters (regular or not) got some serious sickness, the ship doctor can't always safe the day. They have to limit the equipment of the ship medbay; thus some serious problem / injury / sickness have to be sent into a bigger hospital. Some of them can be saved, but others won't.
The other example is, that a ship with the size of Voyager won't have a very advanced replicator that can replicate everything. Just give the job to the industrial Zone in Earth or other Federation core members planet.
A ship can't be too independent just like the USS Voyager in Star Trek Voyager. They should have limitation. 7 years in outer space without support should break down the ship to an extend that they have to downgrade the ship capability (because they can't replace the broken parts along the way), or they have to replace the Federation tech with the Alien ones (from barter, etc, with the local that they met along the way).
So, the main problem is the very thick plot shield that they put into the regular casts; as they can't die in any way in the show.
Just imagine, if they remove the plot shield (so all regular casts can die in any moment), yet they have to protect the captain from being dying in an episode, would they put Captain Janeaway into the experimental shuttle and let her evolve into a creature? That decision can kill her for sure.