Back in the Nintendo era we picked up a copy of Final Fantasy I when the local rental shop went out of business... The battery in it was 100% dead. So my brother would just leave the Nintendo on.
I don't think I've had a console affected by this though.
Recently I had an Evercade cart die. It was the flash memory that gave up, though. Not the battery.