We wintered there for 6 years and loved it. Would probably still be dragging a trailer all the way from Ontario Canada back there today had we not been required to be within a direct flight home to respond to an aging MIL with frequent health problems.
We ended up in Florida that winter and property prices were so good we bought a home. The RV and custom Toter got sold as soon as we returned home to Canada the spring of '10'.
While in Yuma, we enjoyed the ease of driving around, golfing, dune cruising, mine exploring, desert hiking and Harley riding all over the place.
There's lots to do there if you simply read the trades papers for scheduled events.
The dust was of some concern due to allergies but certainly didn't make the place a deal breaker for us. We used a double cannister filter package on our RV so neither drinking nor laundry was a concern.