But you asked the question! Don't get down on the guy for answering if you don't like the answer. Every 18A I know is extremely smart and knows their job inside and out. They are also very humble and you would never notice them. I spent a lot of time living with those guys and admired their preparation, intelligence and humble attitude. Your job as an officer is to lead, communicate, make decisions, whether on a team or infrantry. As a guy on the teams or platoon or company commander, sure you will pull the trigger, but not like the other guys. Why? Because you could be calling for air, coordinating with another team to make sure you don't shoot each other, looking at a screen figuring out where a marked bad guy is, resupply, calmly for arty, talking a mortar pit, medevac, etc. There is so much technology and communication on the battlefield it is unbelievable. As an officer, you have to know it, how to use it. Communication within your team and outside your team will occupy a huge part of your time while in the field operating. Also as an officer your window to be 'that guy' is very small before you move on up to positions that become non-tactical. Who is the Ops officer, XO, commander? You will eventually and those guys aren't pulling triggers in the large majority of cases above company command. On the teams it's even smaller. You do your time, get promoted and move on. You won't be on a team operating forever and even infantry beyond company level you aren't doing a ton of maneuver unit stuff where you are really doing tactical things.
Have you read Lone Survivor? Those guys sat on OPs for weeks literally sitting and watching. Extremely hard and monotonous work. Not glamorous at all. Training foreign militaries is a huge part of the SF mission. That isn't exactly knocking down doors. You are right, it's not video games. It's great you are excited for the future, keep the enthusiasm, but realize the military is less video game coolness than you could ever imagine.