The arcade games in Grand Theft Auto: San Andreas come to mind (though they're short and repetitive enough that they feel like minigames).

Donkey Kong 64 - with the original arcade DK - also came to mind, but I can't remember if you can play the original DK in-game, or if you just unlock it.