Standard cannons and Large cannons are pretty interesting weapons but they have the issue of taking a lot of frontal space that's not really fixed by the overclock for large enough ships.
They are quite difficult to protect, not having enough pen resistance to protect against LCs and above, and their dps, while decent for their price, is absolutely too low for something that will probably die quickly (because front mounted) I think the highest "optimised" full frontal cannon build that's viable for carreer is around 900k (higher for avoiders, but I'm considering that you have other ships to worry about in carrer so I try to exclude direct control ships as much as possible in my reasonings for career).
I think there should be a way to further increase the survivability of frontal guns. Losing dps as soon as the fight starts is too punishing. If lose 20% of your dps from a DC volley while you still haven't scratched the opponents paint, it's pretty obvious what way the fight is going.
This is even more obvious now that thermal weapons are a thing. As a budget weapon, where you use numbers to your advantage, you do not have the money to spend on expensive piping and cooling, unless you're already using overclocks. But even then, all that supplementary piping is a weakness in your already squishy armor. All my frontal cannon designs use some sort of internal armor shell to separate the guns from the rest of the ship. It sadly gets in the way of logistics, as you don't want factories on sacrificable parts of your ship.