But yeah, I can't really think of a situation where its useful either.
FlashGet (a download manager) has the option which I find damn handy when I download large stuff (I miss the days when game demos were a max of 20mb...), so I just toggle the "Shutdown after Download" buttton, hit the bed, and let the PC shut itself off.
(used it all the time as a dial-up user)