U.S.S. North Carolina - Fleet Defiant
Consoles have been upgraded with fleet versions and such, but it's a start to a pure damage build. Excels in PvE and PvP with a decent team.
For the Assault Cruiser, anyone here or the STO forums can teach you how to build an Aux2B build. It's the current OP, I win button build right now. Ever since it's creation, Cryptic has been making their new Zen ships tailored to run the build with the way they make bridge officer layouts. So if you go with it, you will be able to fly a variety of ships.