Dropbox works if you add the "?dl=1" query variable to the share URL, but you can run up against their daily quota very easily which shuts down your account for a day or two.
Here's a sticky thread that discusses many video hosting options:
http://forums.roku.com/viewtopic.php?f=34&t=34726
www.InstantTvChannel.com / www.InstantSubtitles.com - 717-441-4386 - Build a Roku SDK channel in 15 minutes! Easily and inexpensively generate subtitles!