In early 2009 I bought an octo mac pro with Snow Leopard and 6 GB of RAM.
Although I have reloaded Snow Leopard thrice, it remains the exact same configuration: same mac pro, same 8 GB RAM, same Snow Leopard.
I have not run into any problems whatsoever. I run a perfectly modern browser with 30+ tabs open, I run multiple guests in VMWare Fusion and I don't miss having the app store at all.
In a few months, this will be seven years of platform stability. I have enjoyed it immensely.
Further, provided nothing too sticky comes up with continuing to run Snow Leopard, I think I can add one of those bootable PCIe SSDs and max out my ram and run this to the 10 year mark.