Better safe than sorry I suppose, but I've been putting all of my Macs to sleep every night since 2003 and not once have I had an issue with them waking back up.
The whole purpose of sleep mode is so that you can quickly get back to work on your machine, so you definitely want to leave all your applications open.