I use NES and Sega sounds. My buddy uses Zelda secret area find sound its pretty sweet. I use sonic checkpoint. And I had faxanadu for my ring tone at one time. As soon as cm10 incorporates sounds for the s pen I'll figure something out.
My suggestion is to name the sound as what you use it for on your sd card. Like "gmail notification" so if you flash a new ROM its instantaneous to setup new sounds.
I changed a few.
When I receive mail a ladys voice speaks "Gmail" or "emailb depending on the account.
Any facebook notification and a lady speaks "facebook".
Text message triggers a ladys voice saying "text".
Comes in handy when driving.