I second your Joyent recommendation. An article of mine made it to the top of Hacker News' frontpage - said article is hosted on one of their SmartMachines w/only 256megs of RAM… running blogging software I had written myself. And it held up fine!
To fit within the confines of that amount of RAM, though, I've since switched to nginx… :)