In my humble opinion, it would be Cyberpunk 2077 and GTA V with realistic mods.
GTA San Andreas Nova Iguaçu was just too good.
Another game that also turns out really good is Skyrim.
Of course, not every mod is good; there are some that even ruin the gameplay experience, like the mod for Silent Hill 2 remake without fog.