I'm using Lion right now and apart from auto-save--which still sucks (and was just a dumb idea, as it has destroyed more files than it has saved...what ever happened to being able to NOT save changes)--it is usable because a lot of the annoying things can be turned off, leaving me with (almost) exactly what I wanted: the most up-to-date version of the sophisticated yet smooth Mac OS. If all the crap is mandatory on 10.8, and so is the Mac App Store (apparently there will be no more software updates, no more dmgs), then it seems that the once great flexibility provided by Mac OS will be gone completely. Mac OS, err, excuse me, Apple OS X, will be like Windows 8--a consumer-based OS that is focused on things like facebook and is designed for phones and tablets.
FreeBSD anyone? It's Mac OS's older, nerdier and more anti-social brother. I guess I could get used to KDE...
Autosave and Mission Control are the main things that have kept me away from Lion as of now. In Lion's defense it actually does not look that bad compared to many of the alternatives, but if Mountain Lion is going to continue on the iOS path, I'd rather continue to use what works for me. And I totally considered a dual boot of FreeBSD on my Macbook haha, but figured it wasn't worth messing up something that works great as it is.