I think you'll just have to start calling places for their annual rates.
It would be difficult to find an area that would be good for both summer and winter temperatures. You mentioned Arizona. You might look into the parks in Benson, AZ. It's a little higher elevation but not too high for winters... about 3600' EL. The summer temps aren't quite as warm as Tucson or Phoenix and the winters have some cold nights but warms up during the day.
Put your name on the Escapees Co-op park in Benson. Lots of year-rounders there and it's a great, friendly park. No pool though. It would be difficult to find a cheaper, nicer one.
https://skpsaguaro.org/
CT RV Resort (formerly Cochise Terrace) might be another one for you in Benson
https://www.ctrvresort.com/
Texas would probably be very reasonable but hot in summer and cold in winter, depending where you are.
Gulf Shores, Alabama is another good one or in the vicinity but again, hot in summer.
Basically, there's no perfect place! You just have to decide what's important to you. Good luck!