I made a free website called City Filter that aggregates a lot of data from cities around the world and lets you filter them by different criteria including temperature and rain, but also safety, development, population, distance from your location, etc.

If your goal is to identify your favorite cities based on your own criteria, you will definitely like it:

https://www.city-filter.com