The Hermes class Ursa Minor manages to defeat the rogue Section 31 ship but is caught in its shockwave and destroyed (which is the most dangerous thing in Star Trek Legacy Ultimate Universe mod, which these screenshots are from).
Typhoon Class from Star Trek Online (not to be confused with the Typhon Class)
Kind of a TMP era warbird. From Bridge Commander Remastered: Orion. Model by Starforce Productions.
Proxima Refit from Star Trek Online
Like many other Wolf 359 ships it just has two appearances, and one is a mod. Probably modded into other games I don’t play as well, so feel free to add more below!
TOS style Salcombe kitbash
Ahwahnee Class from Star Trek Online
From Bridge Commander Remastered: Orion. Model by Cleeve.
From Star Trek Online. Still think the Enterprise-A should be there - it had more adventures than the Stargazer!
From Bridge Commander Remastered: Orion mod.
From Star Trek Legacy Ultimate Universe Mod
From Bridge Commander Remastered: Orion
Wells Class, from Star Trek Legacy Ultimate Universe Mod
From Bridge Commander Remastered: Orion mod, originally from Invasion for the PS1. Model by Aad Moerman and Starforce.
From Star Trek Legacy Ultimate Universe Mod
Warden Class from Star Trek Online
From Bridge Commander Remastered: Orion. Model by Anduril and Zambie Zam.
From Star Trek Online