I usually avoid these conversations about the military, because it's such a hot button issue. I have many family members who were/are in the military. I have one family member who died in WW2, buried in a US cemetery in France.
> but military training is mostly about obeying orders
Not at all. The military wants individuals to think for themselves. Strictly obeying orders would never get the job done. In fact, the large majority of military training is industrial/trade depending on the branch. When people see bootcamp, and orders being thrown around that's less of learning to obey and more of making people into a cohesive team (breakdown, then buildup). Think about how tight a startup team is after going through hell to get a product launched. Very similar but even tighter.
> that biggest thing soldiers have missed in their civilian lives is the adrenaline/joy rush of a shoot-out, no matter how dangerous it is
A very small percentage of the military ever gets in a firefight, again depending on branch. Of course there is an adrenaline rush that comes out of being in danger (just shooting guns in general is a rush). Every time I paddle out into big surf or when I have sky dived, the chance I may die is part of the 'fun'. I've never been in a shoot-out, but from what I've read it's those experiences X 100 or more. Finally, these are the exact type of people we want fighting. The best way to survive and win is to go all in 100%. When someone is there, on the ground being shot at, the time for them to debate is over.
> Seems that soldiers are fine with killing "the enemy"
Keep in mind that the US has strict rules of engagement (mistakes are sometimes made as reports have shown). By the time a soldier is killing the enemy they are also going to be receiving fire. Effectively if they do not kill this person, this person will kill them. Seeing friends die is obviously hard because they are your friends, and because of the way teams are built people end up very close.
With all that said, the military is the execution arm of politicians. A soldier on the ground has about as much power to decide to be in or out of war as you or I. People join for a lot of reasons. Financial is a common one. But, a lot of people also join out of a duty and a draw to be of service to a country they love regardless of who is POTUS at any given time.