It should be hight risk hight reward death incarnate.
No unit should fit that role in CoH2, ever. It's just bad design that ends up frustrating everyone.
-For one, there usually are ways to mitigate the high risk part of the equation which leads to overpowered units. Think back to the old Tiger Ace.
-It leads to formulaic meta gameplay where the high-risk high-reward unit is always going to be the best choice in specific situations. There's already too much of that going around. We don't need more.
Sturm Tiger isn't in a good place now but stretching its cost/performance to extremes isn't the way to fix it.
Edit: If anything, the Sturm Tiger is carryover from the initial (and very flawed) design of OKW that was heavily based on high-risk/reward.
If you managed to keep all your trucks and vehicles alive through mid-game, you were very likely to win, but if you lost any of your fuel investments, it would be an uphill battle to stay alive.