There are some games that don't work or don't work as well. Some anti-cheat systems don't work but the website protondb.com will tell you how compatible specific games are. For some people that's a deal breaker and that's ok, hopefully as adoption increases the situation will get better. I was disappointed to find out that vermintide 2 doesn't work for example.

I have no idea on the pirating side.