Thanks for the advice.
Looks like the Camelback has some weird blackout policy on point stays, so that narrows it down to the Desert Ridge and Marriott McDowell.
The resort amenities of the Desert Ridge are appealing, and the McDowell does look a bit aged and the airport noise seems to be a common complaint.
There's just something about paying a resort fee (even if possibly reduced for elites) that irks me.