I'd personally hate to live anywhere near Parramatta Rd if it meant I had to go along it, it is one of the worst roads in Sydney IMO, if not the worst.
It will be noisey as all hell. I live in a unit facing Sydney Park Rd and the traffic along there while nowhere near as busy as Paramatta Rd...