I don't sweat the numbers on the sheet as a PC or a DM. I generally prefer for everybody to be focused on playing cool characterization concepts that are fun to interact with rather than try and emulate any specific sheet stat.
Generally as a player I don't look over other character's sheets, I just interact with them as characters. The portrayal, the characterization is the point of interaction, and so that is what comes across as of value or not.
My roleplaying guides personally are usually more a concept (refugee who is poor and starting anew, noble aristocrat duelist, act like you are in a Frazetta painting, etc.) or just playing and riffing and seeing what develops.
D&D stats are multidimensional to the point that you can justify most anything under any stat. Someone who is ugly but charming could reasonably be represented in most D&D edition charisma definitions with a low, average, or high charisma.
I know plenty of smart people who are regularly dumb in one aspect of their life. I am completely fine with saying a high int character is a technical specialist in their field of wizardry and their mechanical int skills for skill rolls while having the individual character be whatever in how they come across in thinking through problems and decision making.
For me a big part of RPGs is the immersive experience of being the character in the moment. Thinking about trying to emulate stats takes away from that a bit.