The more things you try to make a single machine do, the worse it is at any of them. Look up the Main Battle Tank 70 project. It quickly became over complex, over sized, over weight, over budget, overly fragile and too frigging slow on any terrain. The prototype became an exercise in everything NOT to have in a main battle tank. IIRC, the designers of the M1 Abrams used the MBT 70 as an anti-inspirational device.

Now take the MBT 70 concept, give it powerful jet engines, wings and the ability to transform into a giant robot...
Another exercise in military hardware over enthusiasm was the Crusader artillery piece. The idea was spiffy. A single gun that could automatically adjust angle and firing times to simultaneously drop eight shells on a single target. Very un-spiffy was the thing was too big to be airlifted by a C5-A Galaxy and too heavy to be able to cross most of the bridges in its expected theater of operations, which it would have to be transported to by ship. Kudos to Rumsfeld for axing the waste of money. There's a fire and forget round for the M1 that can do the same job for a lot less money.
For fictional silly, David Drake's hovertanks. They seem like they'd be cool, but I can think of many ways to defeat them. Immobilizing them would be easy with a dry moat covered with a metal grid. If they got over the grid they'd drop onto it since the air would just blow through. Immobile non-hovering tanks. Another method, pop up mines that blast horizontally just above the ground to punch lots of holes through the tanks' metal skirts. *thud* More immobile targets. Depending on how well the fans are protected from threats above and below... mines that pop up fast enough to get past the anti-personnel charges then fire something downwards through the fans. IIRC one of the books has a scene where a mechanic is under a tank working and he can see the fans. Hellooooo, big minefields that blast lots of shrapnel upwards. They wouldn't even need any electronics, just an air pressure driven trigger to pop a percussion detonator.
The anime I've seen that has the best excuse for giant mecha* fisticuffs is Evangelion, but that's only because some of the 'angels' they fight are expressly intended to close to beat-em-up range with the EVAs.
*But of course they're actually giant organic humanoid constructs wearing powered armor/restraint suits.