It’s vastly better than it was 5 years ago. You can get an idea by going to protondb.com and looking at games. Basically, most games work out of the box with minimal to no issues. Even most new games work on release without major issues.
The biggest issue is anti-cheat and DRM. That can be a show stopped for some users, but for me it hasn’t been an issue.