For me Node is useful when you need a non-blocking HTTP server. I'm currently working on a stats/analytics thing, and it works as the API layer between Mongo and incoming requests. I believe geolocation data company Simplegeo does something similar in terms of API glue in front of Cassandra.

It's most definitely not a sledge hammer, but it's a great tool for your stack.