Torrente, the Dumb Arm of the Law (1998)

Torrente is a lazy, rude, alcoholic, sexist, racist, extreme-right-wing Madrid cop, a despicable character who only cares about himself. He lives in a decrepit slum with his wheelchair-bound father, whom he treats quite badly. One day, a new family of neighbors move in, and the sexy younger daughter Amparito catches his eye, so he befriends her nerdy brother Rafi to get closer to her. At the same time, he discovers that a band of drug traffickers are operating in a nearby Chinese restaurant; he knows that if he cracks this case, he could regain the status he lost within the police department; but the only people he can count on to help him are Rafi and his equally-nerdy friends.