I once updated my graphics driver in the middle of a CS match. There was a second of black screen, a few seconds of lower frame rate, then everything was back to normal. I was amazed.
A lot of applications don’t handle the DEVICE_RESET event, though, so you’re likely to see them crash if the driver resets. Firefox used to have a bug where video playback stopped working after a driver reset, but that’s been fixed.