Staid (relatively), well-run, weather like Seattle, not too many tourists - try Bilbao
Medieval, and cheap - Toledo, Avila, Granada
Sun, music, dancing, tourists - Malaga
Better music - Sevilla
Big city and international airport, and generally grand - and @1.5-2x as expensive - Madrid
If you go to Sevilla, you must go to the Flamenco Show at the Tablao El Arenal. Fantastic!
If you want to check Spanish real estate prices, or rents, or holiday rentals, this is a wonderful site -
Rentals in Ronda for instance -
https://www.idealista.com/en/alquiler-viviendas/ronda-malaga/
Thank you.