Hard to believe that this thread is still continuing. Yes, there are a lot of Mac users out there who are not happy with Lion. However, from what I can read, the majority of them have old hardware, out-of-date software, and/or 3rd party software.
A lot of these issues presented in this forum were address in the World-Wide Developers Conference video back in June. It was clearly stated that "Frontrow" was not present in Lion. It was also stated that Launchpad, and other features, were "IOS like" in their functionality. The "natural" scrolling feature was presented. And, the list could go on.
Before I upgraded, I watched the video, browsed the forums (since the WWDC gave the developers advanced copies of Lion). Basically, I did my homework. I also made a complete backup of my MBP prior to downloading and installing Lion. I also made an "Install Disc" for Lion, after I download it (and prior to installing). (I discovered this tip on the MacForum). Thus, the transition has been smooth and enjoyable.
Yes, I have discovered a couple of things that I wish were different. For instance, the disapperance of the "Save As" feature is a bad thing in my opinion. Also, the inability to control "Versions." However, none of these things are the proverbial "deal breaker" for me. I do like the ease of Lion. Safari 5.1 operates more quickly and smoothly than its predecessor. Again, I could go on.
As a future caveat, always research first, then respond with knowledge.