Manhunter fucked up by deviating too much from the book.
Red Dragon fucked up by hiring a hack director and winking too much at Silence of the Lambs.
Both are deeply flawed adaptations of what I consider to be a far superior book to Silence, though the adaptation of that is pretty much flawless, which is why it's a better film than either of the RD adaptations.