I believe in order to use user directories (like allowing ~/Sites/ to be accessed at http://localhost/~username/) or to get httpd to run at startup, you will need to do a little tweaking. I unfortunately can't test how easy it is to get the full functionality of the previous versions back since my Apache configs did not come from a "clean" 10.8 install.

Awesome! This is more than enough! Thanks a lot. :) If you do find out how to configure the use of ~/Sites/ then please tell me. ;)
–
GreduanOct 5 '12 at 2:44

1

Some preliminary poking seems to indicate it has to do with making sure mod_userdir is active and that /etc/apache2/extras/httpd-userdir.conf is being properly imported at the end of the main configuration file. If ~/Sites already exists, that may be all you have to do...
–
NReilinghOct 5 '12 at 3:04

The only thing that changed when I unpgraded was my custom *.conf directory was nixed from the /private/etc/apache2/httpd.conf file. I ran />httpd -S from Terminal and it pointed out the error of my ways.
–
ShanimalOct 5 '12 at 14:46