In Ghost in the Shell Togusa is the youngest and most naive member of Section 9, and the only one who is not a cyborg. Unlike the rest of the team, he's not an ex-special forces member but used to be a regular police officer. He's also the only one who has not yet become completely cynical, but the job is steadily pushing him into that direction as well.
The Major. Her attractiveness is of course completely artificial; the exterior of her prosthetic body is made of standard components, meaning that there isn't a speck of individuality in her sexy frame, and people can easily recognise her as a cyborg, but also mistake her for a cheap model.
Could be considered an aversion — his youth and attractive face could be seen as serving to highlight the fact that he's inexperienced and idealistic, rather than simply giving the viewer some eye candy. Not that he's "ridiculously" young or good-looking anyway.
Psi-Judge Anderson in Judge Dredd. Made even more blatant by the fact that she's technically in her 50's but often looks like she's in her 20's.
Also, Psi-Judge Karyn. At least, until she becomes possessed. Seems to be a trend among Psi Judges.
Judge (now ex-Judge) Galen DeMarco. A Judge so hot, not only was there someone at her Watch House willing to violate the rule about Judge-Judge relationships, but even Joe Dredd was implied to have been tempted.
Dick Grayson joined the police force as a part of his goal to clean up Blüdhaven. Several story arcs focused on the tension between his activities and what was originally supposed to be a just a cover.
Sara Pezzini from Witchblade. The writers noted that as she was not just an officer but a detective her attractiveness would actually be something of a detriment in many parts of the job.
Sara stops being a Hot Cop when she quits the police force in inssue 150.
In the new universe Dani is also a police officer for the NYPD.
Foxxy Cleopatra from Austin Powers. She shows her badge to Austin and goes, "You have the right to remain sexy, sugar," to which he replies, "Ooh, I hope there's a search involved." Granted that they weren't being serious at the time.
Officer Lenina Huxley, and her usual partner, from Demolition Man. Justified, because in Demolition Man, the police force had become little more than ornamental, so more attractive officers are probably given preference.
"Hottie Police Officer" from A Night At The Roxbury. She's played by Jennifer Coolidge, who one year after Roxbury, would forever be immortalized as the MILF in American Pie.
In the German film Knockin' on Heaven's Door (1997) the protagonists get the jump on two police officers. First they order them to hand over their guns. Then they tell them to strip. Cue the male police officer putting on a big grin as he looks over at his partner, who's a hot blonde female (when we later see them tied to a chair, she's wearing sexy lingerie).
In The Cannonball Run, upon being pulled over by highway patrol for speeding, Adrienne Barbeau's character attempts to re-use a previoustactic of pulling her driver's license out of her cleavage in order to be let off. In this instance however, it turns out the patrol officer is a female, with a rack just as big as hers.
Gracie Hart from Miss Congeniality. Although she starts as a mess of a woman, her looks are a plot point, since she's the best candidate to go undercover at a beauty pageant despite her unladylike demeanor.
Lt. Karrin Murphy in The Dresden Files, as well as Connie Murphy, her TV counterpart.
Deborah from Dexter. Deconstructed, as it just means she gets to dress up like a hooker for stings.
Eve Dallas in the In Death series is described as one of those people who is very attractive, but puts no effort into it. She does get a better wardrobe after marrying a member of the Fiction 500, though. Troy Trueheart is also very much this. Eve has commented on his hunkiness, and she usually does not seem to notice or care about such things.
It should be noted that Eve has Boyish Short Hair, hates make-up and makeovers with a passion and has incredibly poor fashion sense (her husband fondly remembers the ugly grey suit she wore when they first met like one would remember a spectacular train wreck)... and she's still considered hot, so much that there are a few cases of Even the Girls Want Her.
Angua, Salacia von Humpeding, and Carrot Ironfoundersson from the Discworld novels. Constable Reg Shoe also looks quite young for a cop, although the fact he's been a zombie for years makes his appearance a poor indication of how long he's been ali- er, around.
Captain Holly Short of the LEP from the Artemis Fowl series. She's also pretty Badass, and an Elf.
In the Stephanie Plum books, even cop-phobic Lula (a former hooker) thinks Morelli is seriously hot. Most women in the series agree with her.
Arbitor Shira Calpurnia, protagonist of the Enforcer trilogy.
Detective-Sergeant Rinus de Gier, of Janwillem van de Wetering's Grijpstra and de Gier mysteries, is a male example.
In Michael Connelly novels, FBI agents Rachael Walling and Eleanor Wish (briefly) are both considered this.
Live Action TV
The Major Crime Unit of Cascade, WA's police department in The Sentinel. Especially Det. Rafe.
Quite a number of characters in The Bill, such as Phil Hunter, Zain Nadir, Sam Nixon and Emma Keane.
Especially (age wise) PC Beth Green. On her first appearance, PC Valentine remarked that he "didn't know the station was running a creche". Her actress, Louisa Lytton, was too young to join the real police when she started filming. Lytton won Sexiest Female in the 2005 British Soap Awards- aged 16. She looks that age now...
Ironic given that when The Bill first came out one reviewer praised its realistic look, especially referring to the lack of excessively attractive actors on the show.
One former Inspector was played by a former lads' mag model.
Mulder. Tall, dark, handsome, troubled, frequently shirtless or working out...
Scully. She started as a cute young woman, and ended a complete knock-out. Somewhere around season 4, they stopped dressing her down and she started to wear tighter clothes.
In the fanfic world, there's also a sizable block thinking Skinner is hot. There is a segment of one of the gag reels that features him stripping down to his skivvies to "I'm Too Sexy". He had quite a few Mr. Fanservice moments.
Crews and Reese, the main characters of Life, are both ridiculously good-looking.
Subverted in Doctor Who, where the attractive Amy Pond initially appeared wearing an improbably short-skirted police uniform. This was shortly revealed to be because she's a kissogram, a mostly defunct profession now supplanted by actual strippers.
Almost every single main character on ABC's High Incident. Notable examples include this guy(whose character actually had a moustache. And this one. And this one. Played with in the form of officer Tops, who is a fat, balding guy, and his younger, good-looking partner. Guess which one's the family man? Not Tops.
Det. Ed Green (played by Jesse L Martin), although definitely not unattractive, earns a fair number of points for supplying the sexy voice.
Det. Nina Cassady (portrayed by Milena Govich), who got her press nickname "Detective Beauty Queen" after her role in a shootout at a beauty parlor.
Benton Fraser, in Due South. On the American side, both Rays have their admirers in the fanbase.
Detective Rush in Cold Case. Notably, her actor gets top billing even though she's not the leader of the team, story-wise.
Detectives Valens and Miller count too.
Many of the officers in the Spanish cop show Los Hombres De Paco, including one ironic/hilarious episode where three of the female officers go undercover at a strip club, two of whom actually wear stripper cop outfits.
Several members of the cast of NCIS, notably Tony, Ziva and Kate.
Detective Baldwin Jones, as well as pretty much all the women.
Most of the guys too—David Caruso, Jimmy Smits, Rick Schroder, Mark-Paul Gosselar.
The whole main team of Special Police Dekaranger are, or look, rather ridiculously young for an elite group, and are all extremely pretty.
Not just the main five. Tetsu, one-shots Mari and Lisa, and older-but-still-hotWrench Wench Swan aren't half bad, either. The chief, a Muppet-looking jackal from the planet Anubis, on the other hand...
...gets way more Rule 34 than everyone else put together.
Lt. Cedric Daniels, a lean and statuesque officer.
Jimmy McNulty is something of a manwhore. He's a very handsome manly man.
Kima Greggs is a female example. She has a pretty face and is very slim.
Ofc. Tina Hanlon on The Shield, which becomes an issue when Dutch Wagenbach falls hard for her.
Detective Kate Beckett of Castle. The first episode hangs a lampshade when Castle remarks that an attractive woman like her would under many circumstances opt to become a lawyer rather than a cop if entering law-enforcement, before going on to deduce that the reason Beckett did become a cop is due to something which happened in her past.
Undercover fed Vincent Terranova of Wiseguy was remarkably good-looking, so much so that it ought to have tipped somebody off that he's not the hardened criminal he pretends to be. A real lifelong gangster would most likely have gotten his face smacked around at some point.
Especially as the character is a Golden Gloves boxer.
DC Anna Travis from Above Suspicion, who is played by a 32 year old actress, but looks 19!
Virtually every cop, male and female, from CHiPs, Heather Locklear on TJ Hooker, and Charlies Angels where the three original Angels were all ex-cops.
Sherlock has one of each gender. For those who like men, there's Silver Fox DI Lestrade, who, like most of the male cast, wears well-tailored suits. For those who like women, there's DS Sally Donovan, who's got legs and the gun to back them up.
Once Upon a Time has Emma Swan herself as Storybrooke's sheriff after Sheriff Graham was killed by Regina's magic.
Blue Bloods has Det. Jackie Curatola in homicide, as well as Det. Melissa Baker as Frank's personal assistant. On the Y side of things, Jamie Reagan looks good in a uniform, and Frank is played by Tom ' 'nuff said' Selleck. Danny Reagan no doubt has some fangirls too.
Both Nick and Renard on Grimm qualify, and Hank has his admirers. Even Wu can be pretty appealing.
Some rural areas in Australia have a shortage of women. The Victorian town of Mt. Thomas in Blue Heelers just has a shortage of unattractive women if its police force is anything to go by. Besides Sgt. Tom Croydon, the same is generally true of the men.
Amber Tamblyn was undercover as a prostitute at the start of the pilot episode of The Unusuals. The undercover part ended after about two minutes of showtime, but she didn't get a chance to change her clothes until later in the episode. She looked fine either way.
While most of the cast of Whitechapel are pretty normal looking (though not unattractive), the show also has tall, blond and handsome DI Joe Chandler, and the adorable youngest team member DC Emerson Kent (nicknamed DC Bambi by some fans)
Detective Murdoch. He's a man of dark and mysterious beauty and wears a sharp suit. Quite a few women in-universe fancy him, much to his embarrassment.
Constable George Crabtree is something of a Comic Relief character, but he's good-looking in his uniform. There are some Ship Teases for him with several characters, and as od season 6, he dates the gorgeous Dr Emily Grace.
Constable Higgins is a minor character and appears mainly paired with George, but he is decidedly handsome and has a sweet smile.
New York Undercover to varying degrees and more realistic than the model-types frequently seen on other police shows, but overall, a very good-looking collection of officers.
Psych's Detective Juliet "Jules" O'Hara. Averted with her partner, Detective Lassiter whom is frequently said to resemble Mr. Bean.
There's also Buzz McNab, who was moonlighting as a stripper for extra cash.
Detective Amy Santiago on Brooklyn Nine-Nine. Detective Rosa Diaz is also fairly easy on the eyes, but in-universe at least her permanently pissed-off attitude means that most of the guys seem to regard her with more fear than desire.
Caitlyn, the Sherrif of Piltover in League of Legends. Her "Officer Caitlyn" skin ramps upthe sexy, making her look more like a stripper wearing a "sexy policewoman" costume than a real lawbringer.
Her partner Vi, the Piltover Enforcer eventually received a matching skin. She at least gets pants rather than a miniskirt thanks to being a bruiser rather than a marksman, but if anything her Boobs of Steel are even BIGGER.
In PC-98 exclusive Touhou: Phantasmagoria of Dim. Dream, the maniacal princess Kotohime fancies herself a police officer, though the other characters' reactions suggest it's just one of her delusions. Win the game as her, and in a post-game cutscene she'll even wear a uniform.
Ginga Fukei Densetsu Sapphire has a cast of pretty young policewomen in form-fitting suits.
The Webcomic Girly has a very lampshaded version in the form of Officer Hipbone (note her name, and note her most noticeable physical trait), and Policeguy is considered one of this - to the point where The Casanova had mistaken him for a pretty woman before his haircut.
Justin of Wapsi Square is a male example. While he's more Adorkable than straight-up attractive, the comic's female characters certainly think he fits. One is dating him, and another has a crush on him.
Whateley Academy security officer Samantha Everheart, in the Whateley Universe. Not only is she a hot blonde, but she looks like she seventeen, despite the fact that technically she is old enough to be retired from the U.S. Navy. As an admiral.
Felina and Ulysses Feral in SWAT Kats are sexy as hell.
Elisa Maza and Captain Chavez from Gargoyles. Or, for male examples, you've got Matt Bluestone and Morgan Morgan.
In The Simpsons, Monty Burns falls for Gloria (usually depicted as Snake's girlfriend) on Flag Day as she is giving him a parking ticket. Marge probably counts as one in the episode where she becomes a cop. As for the male officers, Lou doesn't look so bad.
The Legend Of Korra: When it was revealed that Mako is going to be a cop in Season 2, fans of him were ecstatic, with reactions to the rough sketches ranging from "I'm so excited" to "THERE GOES MY OVARIES."
An episode of COPS followed a stunningly attractive New Orleans police officer during Mardi Gras. At least twice she was approached by cops from other states (there as tourists) telling her she was the most beautiful policewoman they'd ever seen.
Jaime Faith Edmondson, Miss January 2010, holds a degree in Criminal Justice from Florida Atlantic University and served on Boca Raton's police force for two years, after which she became a cheerleader for the Miami Dolphins.
Alaska State Troopers - Reality TV show, real Trooper. One of the male Troopers in season one said on camera that the hardest thing about moving to Alaska and becoming a Trooper for him, was lack of a family life. The Nat Geo webpage explains that he got many hundreds of emails from female viewers from this, apparently some of the offers were... interesting.