Imho a heavy tank (or superheavy) should be a more of a lineholder defensive type of vehicle, give the MBT's the offensive punch.
I just remembered this while reading this page. A game called Ground Control 2 had a nice idea for a heavy tank. It was just that, a lineholder.
It's side armours would swivel to the front and grant it extra front armour and made some nice hard cover for infantry (PIC INCLUDED!)