Is a nickname or a real name more intimate?

IRL, when talking to someone, would you say that the use of a nickname represents a closeness, or the lack thereof?Is it that you feel close enough to call another person a cute little nickname, or is it a denial of his/her real presence?

Perhaps I am over-thinking this, but I wonder, generally, if a nickname represents a closeness and comfort level, or the denial thereof.