Not a big gamer, myself, but it seems like Valve has done a lot of work to make many (most?) Steam games run well under Linux.
Drivers have come a long way, and a lot of things just work, but it can definitely depend on what hardware is in your system.
I get a page showing “Error establishing a database connection”