I can recognize that he was certainly trying to be funny in 6 days 7 nights. I, in particular, just didn't find him to actually be funny. :(
Running down his IMDB, it appears that I tried to like him in Air Force One, and I thought he was alright in the Clancy movies (though I do prefer Alec Baldwin (I know, that's weird!) as Jack Ryan) but Sabrina was the last movie I thoroughly enjoyed his performance.
Everyone here has seen Mosquito Coast, right? I saw that for the first time 7 years ago or so... I think it's an excellent film, a unique role for Ford, and quite the little gem.