Mira is a very neatly designed preference pane to make the best possible use of your Apple IR Remote, with support for a bunch of applications out of the box:
Update: Version 1.2 now supports a variety of USB infra-red adapters, and works on all Macs (not just Intel ones).