In PvE it can serve as an excellent form of crowd control, with its 1 minute duration and 1 minute cooldown allowing paladins to keep a single target incapacitated indefinitely. It can also be used in emergencies or in order to allow the healer to catch up on damage. Unlike some forms of crowd control it works with many races - Humanoids, Demons, Dragonkins, Giants and Undead - but bear in mind that many mobs (such as Bosses) are immune to effects such as Repentance.
In PvP Repentance is particularly useful. It can be used as a basic stun/interrupt, halting important casts or giving you time to heal. Its 30yd range means it can be useful against ranged types, allowing you to get close to them while also stopping their attacks. It can also be used along with [Hammer of Justice] to allow the paladin to stun/incapacitate two targets at the same time. Since it breaks on damage, Repentance is perhaps most useful for incapacitating a secondary target (or healer) while focusing on another target, or in order to give you a chance to self-heal.