Snow Leopard is no longer receiving security updates; that'd give me pause in anything but a very firewalled desktop installation.
I upgraded SL -> Mavericks a few months ago when it stopped receiving security updates.
It's slightly worse (I don't like mission control, messages is useless to me) but not as bad as Lion (i.e. you'll just need to disable the stupid scroll behaviour, but performance is good).
On the plus side, you get the option to use new software developed for "10.7+" (heroku's db client, atom editor, swift etc)
It works perfectly. I have zero complaints or issues. It's no problem at all.
I use chrome and terminal for most of my work, but I do run itunes and vmware fusion and run some apps that give me a tiled interface and focus-follows-mouse.
No problems at all. I couldn't be happier.
I am sure it would all go to hell if I got a current model and tried to run SL on it ...