No, not really. Most of the RAM is eaten up by the operating system. DCU Online is getting released on the PS3, pretty soon, and it's a modern MMO.
Push Ctr-Alt-Del and see for yourself. Windows and background thinds, like AIM, MSN and net browser eat some 837 MB, on a barely-month-old system...