A fun campaign i played was where the DM set up the scenario where I, a high level Paladin, gave up on my Diety and basically switched religions. That one was fun.