I have found that Lion is a nightmare for comaptibily with my workflow.
That's an awfully broad brush to tar Lion with, Bryce.
At least you state that it's a nightmare for YOU, but you don't clarify what your issues are, what applications you use, what your machine's configuration is or, in fact, anything at all. So there's no way for anyone to know whether your issues are in any way relevant to what other people may experience. For all we know you're trying to run some antiquted piece of software designed for Mac OS 9.x. I doubt you are, but for all the details in your post you might as well be.
From my own experiences, although I don't have that specific model to test, I find that Lion's performance is at least on par with Snow Leopard - significantly better in some cases. There are some UI changes that take a little getting used to, and your mileage will vary depending on how quickly you can identify those changes that matter to you.
The overarching element, though, is memory. Lion like memory more than previous versions did. It's not that you absolutely need more, but you'll find things run so much better if you have more memory available. Memory is also a cheap upgrade nowadays, regardless of whether you take the plunge to Lion or not.