The Dead Rising games might be good for that. Just save the game, then you can ignore all plot responsibilities and kill zombies with whatever weapons you want/can find.

The Saints Row games are also good, particularly the third. Once you get certain upgrades, you are basically unkillable and have an unlimited arsenal to rampage through the streets and tear through endless waves of cops and soldiers.