I haven't been to the Marriot Camelback Inn, but I do like the Marriot Mountain Shadows. Nice place, decent restaurants. My comapany even had it's Christmas Party there one year. However, it wasn't a spectacular hotel. The only Spectacular Hotels that I've stayed at in Scottsdale are the Four Seasons Resort (which can be rather expensive) or the Fairmont Princess Resort (right next to the TPC). The Resort Suites (next door to the Princess) had very nice rooms, though the grounds are a little cramped, and is very affordable. My company puts visiting executives into the Resort Suites when they come into town.
Most of the Resorts in Scottsdale are nice, the older ones have some cramped grounds, but nothing too terribly wrong.
If you don't have to stay in Scottsdale there are some nice resorts outside of Scottsdale, like the Phoenician, and the Hyatt downtown is a nice City Hotel.
Good Luck.