While you can find a lot of small bars in the CBD with live music, your best bet is to travel to the Inner West. Suburbs such as Camperdown, Marrickville and Newtown have a number of great venues.
The biggest venue in Sydney is ANZ Stadium, with an overall capacity of around 83,500.
According to Google Reviews, the top-rated live music venue in Sydney is the Sydney Opera House.