Ahhh... window manager and desktop environment discussions. Love this stuff.
I agree with the OP's rant about Unity, and the weird direction which the Ubuntu project is headed. Unity's unforgivable sin, in my mind, is that it fails at it's intended purpose: to be a good netbook and tablet interface. I spent a lot of time struggling with it on my tablet (an atom-based plaything I bought on a whim a few months ago), as well as on my 11 inch laptop (sort of a semi-netbook). The whole interface is sluggish, non-intuitive, and inefficient. While I appreciate the effort to efficiently manage screen real estate, it comes at far too much of a cost in usability. As a tablet interface, it fails spectacularly - they don't even have a decent virtual keyboard. Even KDE's nascent Plasma Active provides a better user experience, to say nothing of Windows 8.
Gnome 3 at least has some redeeming features. It's fairly snappy, and has an over-arching design paradigm that makes sense. Unity, by contrast... I can think of nothing good to say about it. I think canonical would do very well to trash it and try a customized version of Gnome3 in the next Ubuntu. But whatever... the beauty of Ubuntu (and Linux in general) is that you can run whatever the hell desktop environment you want.
I've pretty much converted to KDE4 at this point on my travel laptop (with Ubuntu server edition as a base). It is the most complete and functional desktop environment out there right now, and I appreciate the "everything just works" aspect of it. The extreme feature bloat sometimes is bit much, but performance is pretty good regardless. Plus, with compiz you can get tiling using the Grid plugin (super-essential!).
All the servers at work run an old version of Gnome. It's fast, and perfectly serviceable. I hope Red Hat sticks with that for awhile (Fedora drank the Gnome 3 koolaid already)
I always like trying out other desktop environments. Bodhi has been impressing me lately (an E17 Ubuntu variant). It's too bad that none of the major distros ever embraced E17, it really does have
so much potential. XFCE, openbox, LDXE and the like are all quite serviceable, of course. Knoppix, in particular, has a very slick config of LDXE - worth checking out. The tiling WMs are really interesting too: dwm, awesome, xmonad, i3, wmii, scrotwm, ion3. Awesome is probably the most usable, IMO (Sabyon has a nice Awesome based version of the distro). For netbooks and small laptops, I think tiling WMs make a lot of sense. A combination of tiling, virtual desktops and window tagging lets you manage a normally unwieldy number of apps on a very small screen.
Anyhow... I'm still using Windows 7 on my work computer, as well as on my gaming computer. Applications are more important than the OS, and the applications I need run on windows. A combination of Launchy, bblean and WinSplitRevolution gives it all window managing functionality I need