I am going to go all in on a series of ships, that would have been lesser known, in the ST universe. Well my version of it anyway. The Hera is in that group and here is another, fleshed out from an earlier post, the Himilco Class. Himilco was a Carthaginian navigator and explorer of the Mediterranean at the height of power of Carthage.
These ships were comparable to the Constitution class and leveraged some components. Notable for the integrated main engineering, secondary hull for additional science, cargo and shuttle craft space. Only a small number were built and they were used for deep space, long duration, exploration.
Modeled in Wings 3D