I think people who were frustrated with him completely misunderstand. The alternative to Joe Manchin isn’t a more normal Dem. It’s no Dem at all. He was a bonus vote, who helped keep control of the senate, allowing Dems to set the legislative agenda and approve judicial appointments.
And frankly, the alternative isn’t even a normal Republican. West Virginia is one of the reddest states in the country with a partisan lean of R+35.5! Joe Manchin will likely be replaced with a super right wing ideologue. Dems had no right to expect more from Manchin.