Some of the newer PCs aren't too bad with this. My desktop sucks with sleep, but the two laptops I use are pretty flawless (though one's battery is terrible). I haven't shut one down in 3 weeks, and the other in a week. They're pretty standard, too; the good battery life one was around $600.
Haven't used a Macbook, though, so can't compare.