I once had a player roll deception checks for believing their own bullshit.
Character (and player, too, admittedly) was a notorious narcissist hypocrite who would lie to people constantly about shit, even stuff that didn't matter. Just a compulsive bold-faced liar that would play things off as "just joking" whenever she got caught, so, since I felt like fucking with her for always being an annoying shit, and given I had spent 7 years studying communication theory and psychology, I knew that eventually compulsive liars begin to believe their own fabrications, effectively gaslighting themselves into a completely imagined reality. This is especially accelerated by personality disorders, so she started to develop traits from the long and short term insanity table as character flaws.
All very much unnecessary but it resulted in the character being revealed as a lying piece of shit over a period which was fun because they used Deception as a crutch in every single encounter with anyone ever, hoping it would magically get them whatever they wanted. Kind of like a player who thinks a +25 to persuasion means you can just march into the king's hall and demand he relinquish his kingdom but with fucking with people and lying about everything.