Some attempts have been made at "central" listings for these, but I'm not sure any have really caught on. So, the best approach is probably just to search. 
Unfortunately, that can be a bit difficult if you don't have the right search terms, so I suppose next-best is getting a recommendation from someone for your particular situation.
I'd probably recommend starting with either Button Controller or RM (make sure to use a "Button Device" trigger, then you get basically the same UI as Button Controller--a bit different from "plain" RM; do not use a "Button" trigger). That way, you get a feel for what the built-in apps can do.
If you want a community app recommendation, I'm a bit biased since I wrote it, but here's one:
Advanced Button Controller (or ABC) is another popular option. One of the issues I wrote the app above to solve compared to other options was that you only need to choose the lights once, not once for each action/button. So, it's mostly geared for lighting situations, as the name suggests, where all buttons control the same lights, just in different ways. The others are more flexible in what you can ultimately do with the device; there's no reason you need to use them just for the lights in that room or even lights at all.