What vidya has some great artillery anons?

I bet you two are a couple of casuals who've never even heard of the Combat Mission series before.

Well I don't know if this is strategys games only but when it comes to artillery strikes that are big enough to turn a neighborhood in Japan to dust would I recommend EDF 4.1 the shadow of new despair.
The Air Raider class can call down a mortar strike, a gun ship barrage a cruise missile strike and air strikes via a tactical bomber and you even have access to a MLR tank.

The Fencer class on the other hand can be turned into a walking artillery unit by equipping him with two back mounted grenade launchers or javelin rocket launchers. but you can easily blow yourself up if you don't watch out and trust me this will happen a lot.

Nah. You usually get anally annihilated before you even get the points to spawn these. (And they're limited to one as well.)

Skirmish vs AI you do get to play around with them though.

If it gets to the point where you get Sturmtigers the game has pretty much gone on far too long.