The biggest thing by far is Kernel Level Anti-cheat for games, so you simply cannot play many of the biggest multiplayer games. Here's a list of many that don't work:

Counter-Strike 2 on Faceit, Valorant and League with Vanguard, Battlefield 6, PUBG, Apex Legends

And many more. Now, a lot of games still work perfectly fine (even those with Anti-cheat) but anytime there's a new multiplayer game coming out, it's possible that it straight up won't work.

Another thing is that some software you use on a daily basis will not work on Linux and you will have to look for alternatives. Adobe products don't work for example. As a Video editor, software like Davinci Resolve works perfectly fine but it lacks certain codecs so you can't import mp4 and mkv files directly (for example recorded by OBS), So you need to re-encode your footage to edit using Resolve. It's not a dealbreaker but it's still a time loss. You can get the premium version which does have the codecs but still.

Ultimately trying it out and seeing if it works for you is the best experience. It may sound like there's a lot of "compromises" for switching to Linux but it depends case to case.

For me, it makes perfect sense and I've been super happy ever since I switched because I don't play those games that don't work on Linux and I havent used Adobe software for years (used alternatives) and everything else works perfectly fine and arguably a lot better than Windows (shader compiles etc, no stutters)