For the later generation console emulators it entirely depends on the game. Many wont load at all and many absolutely require OC to be at all playable.

For instance, I found Mario 64 (without sound) to be very playable at 600Mhz on the N64 emulator. Go to the threads and check out what others have got working.