Is there a list of Macs and what is the Last OS they should use for optimal performance

[Black]

I don't think it's just Lion that's the RAM hog.
Sometime in later versions of Snow Leopard RAM seemed to have started getting used in droves, likely to coincide with the way something was handled in Lion. Wish I had more precise info than that.