If you have not done the 717, I would say, go for that.
If you do decide on the 717, choose row A window.
And book exit of the wing if you can.
Tongue in cheek, (talking the waffle), just imagine flying without engines on the wings!
Of course, seriously, they are on the tail of the plane.
I have flown the Embrarer, those engines near the tail are indeed noisy, but it does give you learning experiences!
The dash8 is also nice, as others have said, it flies lower, and you see more, and if the plane comes in over the Royal National Park, and over Laperouse, that there has a wow factor, as its so odd that feeling, when you are so close to the water, after the dash makes its last turn to line up for SYD runway 34L/R.
If you sit on row D, sometimes you can see parallel flights, very interesting seeing planes flying in parallel, to come into runways 34L/R.