I imagine there are plenty of indie single-player games that work just fine offline. You lose cloud saves and achievements, but everything else still works.