I'm in a (very) quiet cul-de-sac and don't mind it, especially through the night and early morning. Having said that, if I was ever to move, I think I'd choose a through road as I kind of miss seeing folk walk past, a degree of traffic etc. However I wouldn't want to live in an overly busy street.