Is there a direct relationship between the adsorption energy and the catalytic activty
Adsorption energy is indeed related to catalytic activity, but not "greater energy means greater activity".

As you were guessing, there is an optimum window in adsorption energies for which catalytic activity is maximum, this is explained by the Sabatier principle:


  The Sabatier principle is a qualitative concept in chemical catalysis named after the French chemist Paul Sabatier. It states that the interactions between the catalyst and the substrate should be "just right"; that is, neither too strong nor too weak. If the interaction is too weak, the substrate will fail to bind to the catalyst and no reaction will take place. On the other hand, if the interaction is too strong, the product fails to dissociate.


There is a nice recent paper in which you can find much more mechanistic details.