I think the character of Tyrion Lannister from Game of Thrones would fit this description. He’s incredibly witty and wise, but I imagine that in mundane everyday situations he’d be insufferable. It’d be like having a really smart older brother who constantly has an answer for everything and is always trying to one-up you. He might make some great points, but it would get annoying after a while.