The Paiute neighborhood is actually quite small - not only S. of Camelback, but also Indian School and I'd even venture to say it's mostly limited to an area S. of Osborn to Avalon, with 68th to the E. and 66th to the West.
Link
It's an older area that's mostly aged rental units that is home to mostly lower income Hispanics. Probably 99% of them are good people, mostly service workers who work in the area restaurants, resorts, etc. It's grittier than most of Scottsdale, but nothing like typical "bad" hoods.
Some of the adjacent areas are also a bit older in feel, but are being revitalized due to the Southward march of major projects. The Valley Ho, for example, is a few blocks north and was a dumpy, abandoned mid century hotel that was completely renovated and is now one of the retro gems in AZ.