Wild scenes have erupted near the Sydney Harbour Bridge after a car rolled and crashed during peak hour traffic.