Wishbone: One thing programmers are often no good at is creating assets. Every game needs graphics and sounds, every program needs stuff like icons.
Navagon: So many otherwise wonderful programs have atrocious UIs.
Thanks, this will be something to concentrate on.
Psyringe: Beta testing, suggestions, translations, as has already been mentioned ... some projects also need people to do user support, public relations, documentation, presentation, forum moderation, etc.
Also, if you can already do code injections for other games, you could try a hand at programming small additions. Since you're talking about open source projects, you can join one, install the respective IDE, look into the code, and experiment with it. I migrated from a beta tester to a code contributor (without ever having been schooled in the programming language) in one project.
But it's hard to answer this question on such a general level. Why not pick a project that you really, really like, and ask its developers what you could do for the project?
I didn't list this topic as a question, but I now mark it as solved! Thanks to all for revealing other aspects of development for me to tackle!