I think you might be letting Fredo in the movie bleed into Fredo in the book. I think the novel might describe him as "dutiful," maybe not the sharpest cookie but mostly just lacking in imagination and drive. I think that when he falls apart after the shooting, they say they were surprised because he was a genuinely tough guy.

"All of these men were good listeners; patient men."