I have flown for an airline with WX RDR ON policy and now for an airline with AS REQUIRED policy.
We had far fewer RDR problems in the ON airline. Just my experience.
I don't know how many times I have flown around WX my Effoh was blissfully unaware of. Embedded CB's hiding in a high level cloud cover. Or at night.
While some military systems can't see my radar, others can. Not just in conflict areas, but military air exercises are frequent in Europe. More so recently. It adds another layer of safety as I see it.
Radiation? The modern systems are low power systems, not like the Flash Gordon style RDR antennas of some 30+ years ago which had side lobes that would give radiation in a much wider pattern. So unless you are flying a classic DC 9 or a similar old aircraft, radiation is not an issue.
For me the benefits outweigh the disadvantages which seems to be limited to forgetting to switch it off. Or annoying the other guy.
I can live with that.