If you ever need to find a mod which just takes warfare and makes it even more ridiculous, look at this mod for C&C Generals Zero Hour:

Units include some of the following:
The Super Abrams, which is an M1A2 Abrams tank with a high powered cannon. The cannon is so powerful that the recoil blows the top of the Abrams off when firing, requiring 3 times the reload speed as the turret must be put back on.
The Monster Technical, which is a normal GLA Technical modified with huge ass wheels, turning it into a monster truck. It can crush anything that isn't a tank or building.
The Pancake Crusader, which is a Crusader tank that instead of a turret, has a huge frying pan. It's a melee unit, but when it gets close enough it will slam the frying pan down and crush the victim, which works on most units except of some like the Uberlord and Lead Beam.
The Lead Beam, which is just simply a tank that has a 105 barrel gattling gun mounted on.
The Uberlord, which is a super tank mounted on 4 Overlord tanks, carrying 2 super cannons and can be upgraded to carry to 54 barrel Gattling guns on top.
The Aeleous tank, (which isn't included in the image) which is a super tank mounted with 2 massive jetliner engines that can blow away enemy units and buildings with hurricane force winds.
The Microwave tank, which is a melee unit. When it reaches the target, it pulls it into a microwave and burns it alive.
The Gattling Nuke, which takes a normal Nuke Cannon and replaces the nuke with a 6 barreled gattling cannon firing nuclear ammunition.
The Bomb Truck Launcher, which is a normal fuel tanker truck that can turn it's trailer's tanks into a missile, creating massive fireballs when the fuel inside explodes.
The Landship, which is an amphibious battleship that carries massive Iowa class cannons and a cruise missile launcher. Taking naval firepower into the battlefields!
The Nukerlord, which is an overlord tank which has it's two cannons replaced for nuclear cannons. Can also be upgraded with a 3rd long range nuclear artillery gun.
The Terror-Launcher, which is an SA4 class missile launcher with a suicide bomber that rides on top to steer the missile.
The Terror-Bomber, which is a biplane that drops suicide bombers onto it's targets.
The Sub-Orbital Bomber, which is a spaceship that flies at high speed and altitude using it's drop tanks to make it invulernable to enemy fire. It drops carpet bombs and it's rocket boosters on the enemy, which causes it to have to return to normal flight altitude and speed, allowing it to be shot down.
The Bumper Hummer, which turns a normal Humvee into a bumper car, which rams it's units to cause damage and knock them back. Can carry 5 infantry troops inside who can fire out to add some extra firepower.