There is no such section in StarFox 64. There's a couple of missions where you drive a tank, but definitely nothing on foot. I don't recall any timed missions either, but I'm not 100% sure on that.
I'm sure there's a few games out there where I was off-put by bad reviews, but I can't recall any of them. Well, one- I had a mild interest in Enslaved before release becuase of the Journey to the West connection, but saw a medicore review for it somewhere & promptly forgot about that. Then a couple years ago I found a copy at Gamestop for 3 bucks & decided to give it a go for that price. I ended up really enjoying it- I even bought a different $3 copy at another Gamestop about a week later becuase it came with a mini-comic book. At this point, the price has actually gone up 2 bucks- I guess enough people got interested at the lower price to warrant a bump.