Sydney has suffered some of its worst flooding for years, bringing the city's transport to a halt and forcing evacuations.