I think the Flood being scary is a good thing, the problem is no Halo game made them fun to fight. The Covenant is just way more entertaining gameplay wise. In Halo 3, for example, the Flood I think damages the quality of the campaign.
...
...