Valorant I can't speak to, since I can't play it on Linux.
CS I've played a lot of and it's fantastic just a bit too slow paced/tactical for me. Your right though that it's a fantastically designed game and a really good shout.
Overwatch I strongly disagree with. The maps have clean lines, but with the character design, abilities, and UI they clearly prioritise being flashy over anything else. It's really visually loud for the sake of it and too much for me.
Yeah, I kind of intentionally avoided saying AFPS because unfortunately these days that tends to mean (like with diabotical) games which are desperate to be the most hypercompetitive aspects of quake. Duels or FFA aren't really my thing, give me teams and objectives!
Perhaps unsurprisingly UT2k4 is one of my favorite of all time