I like Duncan Rock as well. Have you been to Quadra Island? I think that's been my favorite.I think that Sund Rock is fairly benign site, easy to navigate, nice life and structure, etc......good ingress and egress. As with all sites in Puget Sound, vis can be an issue and currents need to be considered.
I totally agree that the Waddah fingers are absolutely awesome......but my favorite dive on the entire planet is Duncan Rock...... west of Waddah.....
2nd favorite site is Arena Rock in N CA...