In Florida, you always have the chance of significant rain (also applies to NC/Pinehurst). For a short trip, a washout would be a huge bummer. In AZ, almost zero chance of rain. Florida, especially Streamsong, has very little going for it in the food/drink/nightlife category, if those things mean anything to you, while Scottsdale is a non-golf destination as well as a golf destination and has those in abundance.
For courses in AZ, Southern Dunes and Wekopa stand out, and you could do 36 at Southern Dunes probably with a decent replay rate. Grayhawk is a great facility for 36, but the courses themselves are a bit bland and arguably not worth the premium. Sunridge Canyon is awful in every way except views, Eagle Mountain is always in suspect shape and they have completely lost the course to a fungus at the moment. Legacy and Raven are not destination courses in any way,shape, or form. Talking Stick courses are relatively boring - destination courses that shouldn't be. 2 under the radar courses not mentioned yet are Legend Trail and Verde River Golf & Social, layouts are really really good, they are mid tier in terms of price, both with great views and not far out of Scottsdale proper. No one has mentioned Troon North, which is top tier for both course layouts (36 holes) but also for price, much better courses than Grayhawk but the facility isn't as good for a 36 hole day. Wickenburg Ranch and Quintero could be done as a 36 hole day but it would be a very long day with the drive(s).