Yeah... It's important for the group to be on the same page about what's fun.

Me, I don't really want to do a blow by blow conversation with every NPC. I just want to say "I dazzle him with my brilliant smile and wit, and after some small talk try to learn about what's going on with the royal stable". I emphatically do not want to roleplay that small talk.

Some people, that's the whole point they show up.

I wonder if there's an RPG out there that has complicated and precise rules for diplomacy, but then once combat starts you just make one roll to see who wins.

First part hard yes, but that's actually explicit in OD&D. The slow adventuring pace in the dungeon accounts for probing etc.

Last part hard no, you just need to get more creative with obstacles. Like "traps" don't have to be hidden pitfalls. They can be wizardly match stick puzzles of doom and so can a 10 foot pole be incorporated into the puzzle by delicate magical manipulation by a magic user giving you a free move?

I'm not very creative, I just steal from media I like, but the sky is the limit when you stop playing character sheets and start playing the characters that the sheets abstract the wrote bits of.

In my experience, it pays to have a conversation with the DM out of game time to tell them that they should probably describe whatever there is to see in the room.

If there's no time pressure and no traps, there's no reason you can't just say "I rummage through every shelf in NPCs personal library in search of the book!" or something.

It's all about balance. Looking under the desk and behind the tapestry area fun is you're not tired out from specifically looking in every corner. GM should mention important details and players can interact or not. There's not only extremes of gotcha hidden info and "roll investigation and survival to do the adventuring for you."

Nothing is more fun than rolling for perception.