I would argue that the awesomeness of Perception depends on how an individual DM interprets this bit about surprise, and whether the campaign style involves lots of sneaking monsters. Certainly a dungeon crawl might, but there are many modes of "standard D&D" that would not involve sneaking monsters. IOW it's also a circumstantial skill.
Perhaps. I just think there's so MANY sneaky monsters in D&D (monsters that lurk in darkness, monsters that look like other things, monsters that blend into stone, monsters that sneak just like a thief -- check out how many monsters from the 1e MM modify surprise rolls or otherwise surprise characters!) that there's a high probability of encountering one in "normal play" (whatever that is). Even games of intrigue with humans involve assassins and poisons and traps and ambushes. And the consequences of failing a Perception check, especially at low levels, might be "Death." That's a lot of variables you're taking into your hands when you don't choose Perception proficiency.
I could see games that don't use it very often, but I don't know that those games are very common.
What would be interesting is to log each d20 roll made during a D&D game, what kind of roll it is, what its agency is, and the ultimate narrative effect of each roll. So you'd have, like, Perception Roll/Reactive/Success/Was not surprised; Wisdom Save/Reactive/Failure/Got Charmed for 1 rd; Acrobatics Check/Active/Success/Caught a Thief; etc.
Insight:Your Wisdom (Insight) check determines whether you can determine the true intentions of a creature, such as when searching out a lie or predicting someone's next move. Doing so involves gleaning clues from body language, speech habits, and changes in mannerisms.
Many players I've gamed with have used Insight as a lie detector, both when I DM and when I'm just another player (so I know I'm not wholly to blame for a cocked up DMing style

). Personally, I hate it when players do that because there's no pathos, nothing of interest, just this binary view of motivation and some kind of "D&D NPC questioning protocol" that seems severely pathological.

Not that I have strong feelings about this...
What do you think?
I think that's true -- players use it to confirm or deny their suspicions that an NPC is lying. Lying NPC's also often come across in NPC dialogue or DM body language as she's performing the role, and the effect of a lying NPC is often just "it's a different kind of challenge," so its vitality isn't what it could be. But it's got a use that's pretty unique.
As far as it being unsatisfying...there's probably a few ways to modify it that'll make it a little more satisfying.
First is the idea that Insight isn't a line-item check. You can't tell which statements are true and which are false, all you know is that the NPC is being deceptive and evasive and you probably shouldn't take her at her word. It's a reason not to trust, not a disproof of what she's saying.
Another idea would be to put it behind a DM Gate to link it to the world a little better. In most cases, you can't make a
Perception(ed: INSIGHT! Derp) check UNLESS your characters notice something "off" (such as an inconsistency or a nervous demeanor). Players must pay attention to your RP to note this, so a DM should be confident in their ability to RP some dishonesty. There essentially has to be some REASON you're making the Insight check, some bit of the character's demeanor you're trying to parse. You can't just make one on every character you're talking to.