I can't think of a movie where he plays anything other than a smartass.
Alien Covenant. Albeit, a mostly forgettable movie outside of his character.
He's also an absolutely incredible screenplay writer/director. He wrote Vice Principals and Righteous Gemstones w/ Jody Hill and they're amazing. I haven't seen his horror movies, but he wrote some of the new Halloween Michael Meyers slashers.
Righteous Gemstones should've ended at S3. But I will say the best episode in the entire series is S4 E1, written and directed by Danny McBride (he doesn't star in it, it's a stand alone episode that takes place during the Civil War).
I've heard Danny McBride is the nicest guy in person, and he has this innate ability to make you sympathetic towards the biggest, most selfish, pieces of shit characters. In East Bound & Down, Vice Principals, and Righteous Gemstones I found myself feel sympathetic for his characters and even rooting for them. He's writes the equivalent of weird anti-heroes but for comedy. Instead of Wolverine or the Punisher who do bad things for good reasons, you see this narcissistic selfish person slowly change to become
somewhat better of a person and care
somewhat more for those around him that I think is really easy to relate to. His characters don't become saints, but they become slightly better than S1 E1.