The Movie Job: Reanimated cyborg police officer, as seen in 1987 sci-fi actioner RoboCop.

Desirable Position? Sort of. You do get to do an awful lot of bad guy ass-kicking, but the entry requirements are pretty gnarly. Namely, you have to have been brutally slaughtered by criminals to get the promotion.

If It Existed In The Real World: It'd save the police a bundle of cash, given that you probably don't have to pay a computer-powered man-machine. Although the trade union disputes would be absolutely terrifying.