Personally
Maelstrom R7 has the best ship models IMO, Mainly because they are in keeping with the games Aesthetic. Also since alot of them use stock Textures they also carry over to rebellion looking good.
ZombiesRus5 Sins of the Fallen has 1 or 2 nice looking models but quite a few don't stand up as well to rebellion graphics
also really looking forward to IskatuMesk's release all of his screenshots look amazing
https://forums.sinsofasolarempire.com/374296/page/59/#replies
so far all of his ships.... look incredible
If you want nice looking star wars models get the/a starwars mod...https://forums.sinsofasolarempire.com/411648
If you want EveOnline get the eve online mod... (these look Amazing)
If you want Battlestar galactica Get the battlestar mod....
Star trek.. get the star trek mod... Sacrifice of Angels 2
etc etc
if you just want a new Corsev model for personal use, I would suggest using one of the Caldari or Minmitar models from sins of new Eden https://forums.sinsofasolarempire.com/389504 pictures are here https://forums.sinsofasolarempire.com/412617