It definitely is a site to see, especially pregame. During the tailgate, Army has every helicopter they have fly over nice and low coming off the Hudson.
If you go...make sure you get there early enough to watch the cadets march on
I'm sure its a terrific sight, but I'd rather see our UConn crowd follow your suggestion at The Rent and attend the Husky Walk, enjoy our great Marching Band pre-game, and cheer our team running out of the tunnel. That's much more important.