Media Center itself is designed to nicely handle system sleep, including waking up for television recording and going back to sleep.
The Media Center service is just a simple service needed for talking to remotes on Vista, and doing a couple other simple tasks. It also supports system sleep.
If you're talking about some special service wrapper for Media Center, then I'm not sure. Assuming the wrapper doesn't interfere, I wouldn't expect any problems.
