You'll probably find lovers and haters of Lion in equal measure 🙂.
Personally, I like it but with some reservations. There are some new features I don't use Launchpad/Mission Control and I'm still not too keen on some things that have disappeared on some apps - Save As, particularly. I think there are still some bugs to be worked out - a lot of users seem to have wifi problems and also wake from sleep has the occasional blip.
The biggest problem for some is that some older apps that work in Snow Leopard will no longer work in Lion because Rosetta is no longer part of Lion. Some have been disappointed to find they've had to shell out more cash to upgrade to Lion compatible versions, and in some cases, found there is no Lion version available.
So if you rely on any old apps it's worth checking whether they'll work in Lion before upgrading.
In spite of a few negatives it seems to be rock-solid and I don't think the learning curve is that steep.
Make sure your Mac meets the spec and although it will work with 2gb RAM installed, 4gb would be much better.