I've only seen one truly uncomfortable close up and it was when a dialogue initiated right in a doorway so the camera got pushed right up the dude's nose and I could see the empty space in his head lol

I prefer to play 1st person and I've always been quite okay with the camera angle for talking to someone, personally. It's kinda how I would see people I'm talking to face to face IRL, except I don't have to look down. I only dislike when multiple characters are involved and it does that jump cut to zoom in on a dude across the room. That's not natural at all.