Over the years, controllers have gotten more standardized and are generally well supported. I have a few, and have never had issues with them in Steam (both Mint and Manjaro).
I’ve gotten a few from 8bitdo and they’ve all been solid. If you have a favorite console from your childhood (or adulthood), they probably have one that resembles it.
For most of the games I play, I prefer to have the left stick above the d-pad (like the Xbox, as opposed to the PS). I also recommend getting a controller that has trigger throttles (similar to Xbox or GameCube), as those can be nice to have for many games. This one seems pretty good (I have an SN30 Pro, but don’t love the left stick position).
My other “dailies” include Rogule, Mazelle, and Hexcodle. Sometimes Decipher as well. Check them out!