There are some hardware scalers that work really well. But most that offer good compatibility with a wide range of older consoles cost about as much as a complete high end pc to run an emulator on.
Can only speak for the higher ranks of both games but cs2 is currently unplayable above 25k elo since its almost guaranteed to have 1 out of 10 players cheating. While i only encounter a few cheaters each season in immortal in Valorant.