One of a number of seemingly arbitrary aesthetic rules in our society is that smaller is considered to be better where noses are concerned. This trope is an aversion to that; someone is considered attractive because of their big nose. Named, of course, for the Egyptian queen Cleopatra, who was considered one of the most beautiful women in the world in her time, in spite or perhaps because of this facial feature.note It should be noted that contemporary writers spoke mostly about how beautiful Cleopatra's voice was.
Although women are hit with the whole "smaller is better" thing more, this trope isn't exclusive to one gender.
Also known as Greek Nose and Roman Nose. Compare to Unkempt Beauty, Meganekko, Big Beautiful Woman/ Big Beautiful Man, and Adorkable, other tropes that defy society's rigid standards of beauty. Related to Matzo Fever and Latin Lover. Because Beauty Equals Goodness, this is often the opposite of the Sinister Schnoz.
Attack on Titan loves this trope, with numerous major and background characters sporting unique noses without resorting to Gonk. Annie Leonhart is the primary example, but also included are Reiner Braun, Bertolt Hoover, Hange Zoe, and Mike Zacharius.
In "Asterix and Cleopatra", Cleopatra is drawn with a huge pointy schnoz, under the phrase that "she would be less famous if her nose was any shorter". Likewise throughout the book, characters (including Caesar) comment on how she has such a pretty nose. However, in the later book "Asterix and Son", Cleopatra is drawn with a typical tiny nose.
Goscinny and Underzo note that a large nose is drawn as a size of character-warmth, with all the good (male) characters— especially Asterix and Obelix— having huge, bulbous Snuffy Smith-like noses, while the evil characters have small ones. They themselves have noticed this isn't always the case, since some of the most sweethearted characters in the whole series, like The Ingenue Panacea and Lovable Coward Justforkix, have tiny noses, and some very nasty characters have huge ones, such as Brutus or Tremensdelirius. They said a better rule might be that good characters tend to have round noses and evil ones possess hooked ones, which fits Brutus and Julius Caesar, but Getafix is one of the most good characters there is and has an enormous hooked nose, and Caesar isn't too bad a person at heart either. There definitely is a rule for who gets what nose, but it's a more complicated one.
Note that attractive women (Falbala, Geriatrix's wife) have normal noses, but all the comical women have cartoonish noses. Same goes for the men, comical characters and the Gauls have huge proboscis monkey-esque noses.
The comic's version of Julius Caesar is quite handsome, with his huge, hooked Roman nose being mentioned as a specific Charm Point.
Inverted once in Astérix and the Picts, where the Gaulish women develop a huge shared crush on a Pictish warrior - not because of his great body, vulnerable personality, intelligence and gorgeous red hair, but because his tiny nose makes him look exotic to them.
In one of the Sherlock Holmes movies with Basil Rathbone, Holmes decoys an assassin by using a bust of Julius Caesar to produce a similar silhouette in his window. He quips: "Throughout history, Watson, prominent men have had prominent noses."
In Ocean's 13 Linus disguises himself with a big prosthetic nose which the woman he seduces for a con seems to really love. Although part of it might have been the aphrodisiac cologne...
Egon Spengler of Ghostbusters may count. He has the biggest nose of the cast, but in the collective universes of the movies, cartoons, and comics, he's generally considered the most physically attractive by many female characters they meet, to the point that it may be considered a Running Gag.
In the fairy tale The Prince with the Nose, a prince is cursed as a baby with a really big nose, and as he grows up, everybody tells him stuff like this: "Oh, what a handsome nose you have, so classic, just like Romans" etc.
A play on this trope: In the fourth book of the Uglies series, Aya believes her nose is ugly because it's large (and she hasn't received the pretty surgery yet). Frizz tells her that although it may not fit ideals of glamour, it's unique and still looks pretty in its own way. In the end, Tally convinces Aya to keep it. In the first book, Tally complained that her nose wasn't big enough.
Holly Short, of the Artemis Fowl series, is mentioned to have a hooked nose in her initial description, but is nonetheless described as pretty.
The titular detective in the Lord Peter Wimsey novels is often described as having a beak of a nose. Harriet Vane found him attractive, although it took several novels of Wimsey being a Dogged Nice Guy to finally win her over.
In one Doctor Who tie-in novel (Fourth Doctor), the narration made much of his "patrician nose".
The Fourth Doctor also really likes his own nose, specifically mentioning how attractive he finds it when first seeing himself after his regeneration. He also likes his nose enough that several of his Character Tics involve gesturing with his finger on his nose, such as rubbing it to display thought, or pushing the tip to the side to indicate that someone else is right - which becomes a Mythology Gag when henote more specifically, a distant future incarnation of the Doctor who has taken on the form and personality of the Fourth Doctor again for unclear reasons does it in his cameo in "Day of the Doctor" - "who... nose?"
In the 50th Anniversary Story The Roots of Evil, the Fourth Doctor encounters a statue of the Eleventh Doctor (built by inhabitants of a space station obsessed with exacting revenge upon him). Leela finds the statue handsome. The Doctor specifically does not because the nose is far too small.
Rory wouldn't have the same adorkable cuteness without his big nose. The Doctor assigns him the code name "Nose" because of it, but it certainly doesn't seem to have put Amy off, and the TARDIS calls him "the pretty one" (relative to Amy, who's a kissogram in-universe and is played by a real-life model). Oswin also calls Rory "The Nose" and says he can fence with the Doctor's chin.
On an early episode of Glee, Rachel was told by a Jerkass choreographer to get a nose job. This has some Reality Subtext because Lea Michele had also been told multiple times that if she wanted to be famous, she would have to get a nose job.note Also happened to Barbra Streisand, who Rachel was compared to. In a later episode, when Finn breaks her nose, Rachel is offered a nose job. She appears to be all for it - and not for the reason she says (it could improve her singing) but for the fact that she wants to look like Quinn. The club talks her out of it and convinces her that her nose is beautiful.
Beth: Pretty means pretty. Cute means pretty but short and/or hyperactive - like me.
Lisa: Uh huh. What is beautiful?
Beth: Beautiful means pretty and tall.
Beth: Pretty with great hair.
Beth:Pretty with a big nose.
Beth: Pretty and fat.
Beth: Pretty and easy.
In an episode of Raising Dad Sarah becomes insecure about her nose and plans to get a nose job to fix it. Her friends and family all try to talk her out of it but she's determined to get it. At the end of the episode she talks to a popular girl she'd wanted to be like and hears that the girl wants to have all sorts of surgery done on herself, shocking Sarah who thinks the girl looks just fine. Thus she learns her Aesop.
Vince Noir of The Mighty Boosh has a large and oddly shaped nose. He's also incredibly popular with both sexes to the point that people falling in love with him at first sight becomes a Running Gag. In an early episode he claims that his "jutting" and exaggerated features are what make him memorable and attractive.
Both Link◊ and Zelda◊ have a relatively large nose for Animesque Characters and they are both considered some of the best looking video game characters out there. Here◊ is a picture of Zelda standing next to Peach for a comparison.
Lucy in Despicable Me 2, it actually causes some trouble when it and Gru's long hooked nose get in the way of kissing at their wedding.
Pearl from Steven Universe. It's actually interesting to note that, in the show's original pilot, her original design gave her a much smaller looking nose. The pointed nose she sports in the show proper is actually only one of many changes that were made to her design (as she was the character whose design arguably got the highest amount of changes going from pilot to final).
An old joke: "He has a Roman nose... roamin' all over his face!"
Sarah Natochenny, Russian-American model/stage actress/voice actor in Pokemon is a good example of a pretty young woman with a big nose. She seems to be careful to pose in ways that make it look more beautiful than comical.
The Statue of Liberty has a 4 and a half long schnoz that's a bit long for her 10 by 17 foot face that gives her a look of graceful dignity.
Noel Fielding has a uniquely shaped and self-admittedly large nose but it doesn't stop him from being one of the sexiest men alive with hoards of fans of both genders.
Angela Aki's classic Roman profile, while unusual for a Japanese, is easily explained by her being Japanese-Italian-American, and her nose, while undeniably large and hooked, only adds to her rather unconventional beauty.