The PlayStation 3 has 256 MB of RAM and seems to do ok, as games like Uncharted and God of War show.

It does mean you'll need to be more careful and considerate of how you use that memory though (and admittedly, on a console like a PS3 the OS takes up much, much less space).