Nicholas Cage is certainly an enigma. He can be brilliant, but he doesn’t half pick some crap to get involved in. (Although I’m sure his financial difficulties have something to do with it).
Bruce Willis is another one who does a surprising amount of dross. I think he can only really play “Bruce Willis” though, it’s just he occasionally gets lucky with a great script that suits this character.
John Cusak is another one.
In fact there could be a whole thread on “actors who don’t know how to turn down a bad role”.