Really depends what part of town you want to be in. Wild Horse Pass is supposed to be quite nice, but I think there are places that are more convenient to the sites.
I hear good things about the Desert Ridge Marriott. But, the two people that I have known who stayed at the Westin weren't thrilled with it.
Many of us who live here like the Fairmont Scottsdale Princess. There isn't a lazy river, but it does have a great pool slide and a fantastic kids program. The kids program is available at no charge to hotel guests (you only pay for the kids lunch if they stay over lunch time). My kids spend all day at the kids club and I get to do an adult vacation with my husband. And, the kids love it so it isn't like I am forcing them into it.