Counter to others I'm actually surprised by how little I enjoyed it. I used to play a ton of FPSes back in the day (CS betas to 1.6 heyday) then stopped for well over a decade. Picked up Call of Duty during the pandemic as a means to stay social with friends and told myself barely anything had changed. Boy was this a great lesson that things have, in fact, changed a lot.
If you go back to something as recent as COD Vanguard, you will find the gunplay is likely closer to what you recall. I play in lobbies like Ship Haus 24/7 to get myself warmed up. It is really hard to feel competent dropping straight into a gigantic campaign-style map with skilled players scattered throughout.
The developer of action quake 2, Gooseman, went on to create CS as a mod for half-life.
Urban terror is the Q3 port of action quake 2.
AQ2 still has a small community of players. I get on occasionally for the nostalgia hit. I’ve never found an FPS that’s as fast paced and difficult to master (movement primarily).