This is a great song - inspired and well-crafted. Maudlin it is not. However, any song will drive you nuts if you hear it too often, and in less-than-inspired-and-well-crafted performances.

Bear in mind, however, that, as was mentioned recently on another thread, "overplayed" is relative - I, for one, have never heard "Kilkenny" performed live.