The house also has an exhaust fan on a timer, paired with small vents on several windows around the house, to cycle in fresh outside air. But practically for much of the year we just open the windows for fresh air since we live in the temperate PNW climate, wildfires aside :(
I looked in to installing a minisplit heat pump system last year, but the quotes I got were outrageous ($25k+) plus as a retrofit it's not the most elegant integration. Someday I'd like to do the conversion and ultimately decommission the gas boiler, but at that price tag it's not happening soon.
In the short term I bought one window AC and one portable AC for a combined ~$1000. It's not ideal but we only have a few weeks a year where cooling is really needed, and a few more where it's a nice luxury but not a necessity.
Condensation is - air conditioners have an integrated drip tray which drains to the outside, but if you ran chilled water through radiators they'd all make puddles of condensation on the floor. Retrofitting drains might be possible but I've never seen one and I can't imagine it'd be cost-effective vs installing mini-splits.