Depends on when and where, I'd say. July and August are peak tourist and vacation season -- everywhere that isn't crushingly hot, and even some of the places that are, will be jam-packed full in every way. People leave the big cities and head to the nearest coast, whether it be Mediterranean or Atlantic; lots of otherwise very nice places turn into madhouses. I was in Sevilla ten days ago or so, and the tourism was already booming.
I'm on the Costa de la Luz right now, just outside Cádiz. Lovely area, great beaches, starting up in the city of Cádiz and running more or less uninterrupted all the way east to Tarifa. It's not too bad now, but I'm told that the whole coastal region will fill up, starting pretty soon now. We've had 30-33 C (86-91 F) degree days for several days in a row, and it's not yet July. That's not insanely hot, but it's pretty dang hot in the sun; the Andalucian sun is strong. The siesta concept is a happening idea. The evenings are lovely and long.
Sevilla routinely sees 40+ C (104+ F) days in the peak of summer, as do Madrid and other cities. The weather picture will be quite different, of course, for cities such as San Sebastian, Bilbao, and the northern region. Check weatherspark.com for comparative weather data about almost any location you can think of.
I've been in the Barcelona-Valencia-Alicante area in the September-December time frame and can happily report that the weather is mostly gorgeously perfect turning to mild winter with some light rain, a little hotter in September and on the cool side in November, of course. The tourism at the beaches tapers off sharply in September (Barcelona seems to get heavy tourism almost all year round), but the beaches are still great to visit. It will also be easier to rent accommodations, and the rental prices should be somewhat down from their summertime peak.
Depending on what schedules are imposed on you (kids' school, your work, etc.), you might consider making a September or October visit.
With fluent Latin American Spanish, you''ll be fine. You'll notice the Castilian accent ("grathias" rather than "gracias," etc) and some differences in vocabulary, but nothing that will mess up your day. I speak conversational but imperfect Latin American Spanish and get by OK. My main problem is understanding the fast-like-water-from-a-fire-hose spoken version.