I host my own site, and another for my uncle in addition to running my own exchange server thus providing my own email and pop3 mail for family. It all runs fine on ADSL, uptime is over 95% and I'm more than happy with the set up (I don't hoover so no risk there).
My only 'complaint' for want of a better word is that ADSL does not provide fast enough upload speed. Regardless of the fab 8MB downloads you can get, you're stuck with 256KB upload and that is pants. I'm currently looking into SDSL and trying to justify the cost.