if you're thinking of Chrome, there's a "Warn before quitting" option in the Chrome/application menu. It's saved my ass several times
Every app needs the optional "hold to quit" thing chrome has. RT @broox: cmd+q is too damn close to cmd+tab.