Thousands of people have flocked to the best waterside vantage points in Sydney, some camping out for 24 hours to secure a prime view.