There's only really one game that I searched out (KHII), and I only had to drive maybe 20 minutes to get there. It was good luck.
That said, I drove almost 400 miles (200 each way) in one day to get to a Blockbuster over the summer. Not for a game, but still pretty noteworthy.