Valorant and Edan.gg's defender [1] has the best fog of war system I've ever seen. CSGO has probably the worst; in fact, at one point, the game had NONE and sent player pos's to everyone at all times.
I completely agree, but there are a lot of server-side mitigations that haven't been nearly as explored as I'd hope.