Ya, the movie is much better if you assume that Fredo knew it was gonna be a hit - despite his telling Mike otherwise. After all, it's not a stretch to believe that Ol' Freddie had a bit of the Sicilian cunning in him, and was in fact lying to Mike in the infamous boathouse scene.