I’m not sure what changed, perhaps an OS X update from Apple, but after restoring all /private/etc/apache2/* files and the my /Users/username/Sites/ folder via TimeMachine to a date when things were working it still wouldn’t play ball.

Eventually I came across the soultion, it seems the chmod levels of the default folders had changed so doing the following in Terminal: