I used to recommend this game but I can't anymore. CS:GO is broken in a number of important ways right now:

Pistols desperately need balance.
Netcode and servers are horrible.
VAC essentially only catches the dumbest hackers.
Overwatch more or less an admission that VAC doesn't work well but is also useless.
Movement speed and run-and-gun gameplay style completely at odds with theme of tactical shooter.
Tapping often offers little reward for risk in current spray meta (exception being AK at distance).
Jumping accuracy? ... Really? Why encourage jumping in a tactical shooter? SWEET REPLAYS!!!
R8 revolver... feels like an April fool's joke that never ended and now is just sort of a troll gun.
Non-Prime matchmaking a huge deterrent to new players - testing ground for hackers now.
Prime matchmaking seems like an awkward fix to broken VAC and honestly still plenty of walls/etc.
Smokes still frequently glitch allowing players on one side to see through them.

I won't list toxic community as a negative of the game because there's nothing the developer can do about that. For all of you who want to cite Riot Games' efforts to improve player behaviour ask yourself this one question: have their efforts worked? No. League of Legends has the most toxic player environment I've experienced even compared to CS:GO or Dota2. Competitive games bring out the worst in a lot of people. That's a people problem not a developer problem.

Anyway, in its current form I would not say that spending the considerable time to become skilled at this game is worth it as you will constantly be let down by wonky mechanics, bad servers, and the inescapable reality that there is a constant ebb and flow of hackers in competitive that make any sense of true competition feel absent.

All in all, CSGO will have you asking yourself: am I having fun or is this actually adding negativity and stress to my life? The answer will vary from game to game but in the long run I think most people play this game out of habit rather than having a consistently positive experience.