Whelp with the likeliness that I can run a game being rather high right now... I better start reading
I wonder where I can find guides on how to create great dungeons.
I've read ones that were mostly pointers and ideas... but not many that were in depth.
As for Overemphasis... Yeah. Though for two reasons
1) Dungeons and dragons, the most popular system, is combat focused.
and
2) Systems that aren't combat focused have a billion skills... GOOD LUCK!
Or rather because combat is generally easier to pull off, understand, and make sure all the characters are sort of together on.
Though that is kind of what I like about Call of Cthulhu in that it has a lot of skills but has a good sense of what is useful and what is esoteric (and those skills make you a well balanced person), and combat should be avoided but not to the extent that making a combat focused character is useless.
Shadowrun also has a huge focus on combat, but it emphasizes just as much effort into planning and using your skills to their greatest. Only mediocre GMs in shadowrun lead you down corrodors with constant fights without anything you can do about it, 50% of any run is in the planning phase.
---
The OTHER aspect is what I call "Hey don't you know social-fu?" and DEAR GAWD some systems have it the worst...
If you want to know why "Roleplaying" often gets avoided, that is it right there! The fact that the VAST majority of pen and papers punish you for roleplaying if you aren't the social specialist. It honestly doesn't surprise me that many RPGs actually forgo social skills of any kind.
In my real life group we would often boil down to letting only our most charismatic character speak in any important situation. "I" will admit sometimes I got fed up and chose to speak anyway (with character reasons of course), but that is basically it.
A Barbarian with 7 Charisma isn't socially disabled... They just lack the honey to get people to act out of the ordinary. A person should still be reasonable and a amply witty roleplay should trump all possible rolls.
Combat though everyone has combat covered.