A freak thunderstorm involving a tornado has smashed Sydney 'like a freight train', ripping roofs off houses, blasting open office windows and flipping trucks on their sides.