You need a radiator with a built-in electric fan, this will all but eliminate the condensation.

However it will not cool like an A/C unit, only something like 5°C reduction. This can be enough to get a decent night's sleep during a summer heatwave.

We're talking about retrofitting to existing typical UK radiators. If I was buying new radiators (and paying an electrician to run electricity to them!) then I would want a better return on investment than cooling from 35C to 30C.