For any SQL/NoSQL system, the more RAM, the better. They need as much RAM as possible to cache the data.
If you observed cassandra consumes a lot of RAM even with small dataset, you should tune the GC settings. Besides it, JVM itself consumes a lot of RAM.
If you're running a "real" cluster (i.e., where you actually need multiple machines instead of just one big one running postgresql), then yes, the recommendations there are realistic -- not because cassandra is inefficient but because you will ipso facto be dealing with a large dataset.
Cassandra does scale down (I know at least one site that went live running Cassandra on a 256MB VM) but that's mostly of academic interest to the audience looking for a scalable database. Hence the recommendations on that page.
http://wiki.apache.org/cassandra/CassandraHardware
I can't find any numbers for riak RAM requirements...