I switched to linux before the steam deck came out, and things were already pretty good then, but it's even better now that more folks are invested in it. Since then, I haven't come across any steam games I have major issues with - however, I still have issues getting my controller running (I don't use it often though, so I haven't really looked into that much) and on certain games I have issues if I switch windows while it's running. Generally for me, if it runs, it runs well, aside from occasional issues from needing more ram. It looks like we have similar cpu's, and you have a better graphics card and more ram than me. I can't speak for everything on your list, but I did play some civ fairly recently without any problems. Check protondb for the games you play most before making the switch - and if you're worried, check lower rated games on there for examples of issues and fixes. I suspect it would be fine for you to switch.
I want to give them a chance, I liked most of the times I came across them aside from the previous thread. The previous thread was pretty concerning though ngl - I don't think they intended to brigade but it still happened. I want to have solidarity with them, but so far, coexisting with them has been hard for a lot of people here. I'm hoping they settle down somewhat and listen to their admins requests such as staying out of c/main discussions and not spamming emojis, so it doesn't have to come to defederation.