http://ninite.com is getting close to apt-get for Windows. We're working on a Mac version too.
Things are better on Linux, but not all rosy. Installing Dropbox, for example, is a surprisingly crappy experience (windows popping up, separate proprietary daemon download, etc). That, and way more user requests than you'd imagine, is why we have http://ninite.com/linux now too.