Respectfully, your original post struck me odd at first. Then, reading over the thread, it seems you're simply excited to have two kids going to Texas A&M next year, and you should be!
As someone that went through the Corps and in general experience of going through college, I recommend you allow him the space to explore it. It is a magical time for student and parent alike. But part of the experience is going through the transition from relying on family to relying on yourself, unit, and others.
I put myself through college, but was very close to my mom (who has since graduated herself from this life). But I look back and am very grateful I went through A&M when we weren't so connected by technology, and today, there are ample ways to check in without being there "too often." These days, we have FOW Check In with parents and families; when I came to A&M, you literally drove yourself and showed up on campus yourself. We had no mobile phones, I had to be plan when I could call my mom from a landline somewhere. We didn't have outfit BBQs before games. I did have some very close friends of the family that lived in College Station, Roy worked for the University and I always knew where his office was if I needed him.
Now, don't get me wrong. I am not one of those "Well, in ol' Army days..." types...
I applaud the Corps for changing the check in process for FOW to involve parents and families in checking their cadets in. It really builds community, and is a fantastic way to get Corps alumni volunteers involved and "re-connected" to the Corps. Definitely go to that to check your son in, and enjoy meeting the other Corps parents, as well as any other programming they have that day for you.
Outfit BBQs are fantastic. We didn't have them in my day, but those too are awesome "connectors" of parents to their cadets today, cadets to their mentors, builds community, etc. Definitely attend those as often as you can. Many of the cadet parents become lifelong friends as well by going to those.
Of course, Parent's Weekend, Final Review, and other similar events that are designed to have family there would be great to go to as well.
But outside of that, I recommend allowing him to make his own plans. For example, Friday nights. Leave that to him to learn how to navigate new friendships for Midnight Yell, etc. Go to games separately for the same reason. Looking back, the only times I attended a game as a cadet with my family were just a few away games. I suppose maybe picking one at Kyle Field a season may not be too intrusive, probably one of the lesser out of conference games for example.
I can imagine you are excited (especially since you're posting several months in advance), but I do encourage you to strike a balance of enjoying it with him and giving him his space!