An approach onto runway 25 is going to be the only approach that gives you even a half reasonable look at Randwick racecourse (it’ll be on the right side). You’ll see the SCG a bit further away but won’t be able to see much inside it (if anything). The aircraft would be between about 1200’ and 1800’ on final approach.
How you get to final for 25 depends on where you’ve come from! If you’ve come from MEL you normally are off the coast. Coming from BNE you turn left about Macqaurie Park/ Ryde and then over Frenchs Forest/ Dee Why about 6,000’ before turning and starting the approach from overwater. Pass over the top of Coogee about 2300’ or so.