Any noun (person, place, or thing) that provides comfort to you over anything else. I.e, it makes you happier than any other person, place, or thing can.
Person 1: Hey, why is your pillow so old?
Person 2: It's my comfort queen, nothing else makes me as happy as it does.
Person 1: Damn... that's sad.