Honestly I still like Dalton.
Dalton was fine in the role but the major problem is that back in the late 80's the mainstream audience didn't want a dark and serious Bond. They wanted more of the light-hearted, tongue in cheek Bond that they got for so many years with the Roger Moore films.