End of the day it's horses for courses, what is your intended role in battleships.
There are sniping ships, brawlers, and ones in between that aren't as good at either.
In 0.0 at least every 3rd fleet battleship I come across is an Abaddon, these are excellent combat vessels up close and at range, consumes no ammo, and IMHO is the best all round battleship...Which pains me being a Matari player to say you understand. However it will loose to a Typhoon or Megathron up close or a Rohk or Apocalypse at distance so jack of all trades really.
That said, the Typhoon has exceptional damage and a vast drone bay, but is really only a brawler.
The Megathron is awesome but has a rediculously limited range, unless you are jumping a fleet and know you are going to be fighting on your terms at 0 I'd probably miss this one.
The Dominix has a great tank, does all its damage in it's drones, but is easily the most capable battleship at dealing with all types of foe smaller than itself, although other battleships present a problem, this is also the best PVE ship of the bunch in my opinion..... Warp in, take aggro with that amazing tank, deploy warrior II's kill the frigates, deploy sniping sentry drones, watch the rest of the room die!
The Rohk, is by far and away the best sniping battleship, skill intensive, but so so nasty I've died to these a couple of times myself.
That said, the Apocolypse is also a good sniper, while not quite as good as the Rohk, it doesn't need to reload and it doesn't use tones of ammo, I would take this on POS assaults over the Rohk, but against ships its Rohk all the way.
ECM you can't beat the Scorpion, it owns end of however it has no tank and once it's shields are down it will almost insta pop.
If you are going for a Carrier I would go with Gallente battleships, the Thannatos is by far the most servicable carrier, after that it would be the Archon. Armour tanking is the only answer for a ship like that, all the Carrier spiders I see are amour I have never seen a shield tanking Carrier spider.