The information presented about the inner workings and instructional content of real US military academies has been most enlightening (especially for someone who writes their own Trek stories

), and I thank those in this thread who have been providing it. It seems that Starfleet Academy and a real academy like West Point have a lot more in common in terms of instructional content than I had thought, which is actually very cool.
My take: Starfleet, as a whole, is essentially a fusion of both "the military" and a scientific/exploratory branch. But even that aspect of it is still conducted in a military
fashion; i.e. even the science officers have ranks and some training in military protocols and combat tactics. In any case, it's undeniable that Starfleet is THE primary organization of the Federation as a whole when it comes to military actions and defense.
A lot of people talk about this idea that Kirk was "a soldier", that TOS had no problem referring to Starfleet as the military, and that it was TNG and the other 24th century shows that introduced the silly notion that it isn't. Well... I don't see it. Yes, TNG tries to be more "thoughtful", and there's a greater emphasis on diplomatic solutions, but nowhere on the show did anyone ever say "Oh, and Starfleet is NOT the military, by the way." I will grant that there was a different feel, but it wasn't concrete. And the fact remained, even without something as dramatic and direct as the Dominion war, in TNG when a problem arose that one would send a military unit to handle, who was sent to handle it? Starfleet. So I don't see this massive disconnect between TOS and 24th century Trek with respect to the military status of Starfleet. Well... Except for that one line by Riker in Peak Performance, where he dismisses tactical expertise as a "minor province" in the makeup of a Starfleet captain. That whole scene depicted Riker and Picard as having a certain disdainful "Feh, why do we have to do this uncivilized garbage" attitude toward the tactical training. I ignore this. It's contradicted not only by how important tactical and combat capability is shown to be throughout the show (including in incidents
prior to that scene... Q Who, anyone?), but also by later events in
that very episode: when the wargame simulation actually begins, the E-D crew demonstrate some keen tactical instincts (especially Riker and his outgunned team on the
Hathaway), and it's clear that everyone involved - Picard, Riker, Geordi, Worf, random unnamed goldshirts on both ships - are, in fact, getting a huge kick out of the whole thing.
I think that as one goes through the Academy, your specialties emerge as a combination of what your preferences are, and what comes up during the training (things you are good at that you might not have even
known you are good at), but the balance between technical expertise, scientific expertise, and military expertise is not the same across all officers. Worf, for example, clearly had a strong emphasis on combat and tactics, but also still had a high degree of technical expertise as it related
to tactical systems. A single ship or station would thus have a mix of people who leaned toward one expertise or another, and some who were well versed in all of them. Enlisted personnel, I would think, would tend to have a much higher percentage of those who specialize very heavily in a specific area, and have minimal expertise in most other areas (though, of course, they could pick up other things through practical experience, the same as an officer could). So, if you were to then look at Starfleet as a whole, you find a careful balance between different specialties, disciplines, and expertise, allowing for a great deal of flexibility and adaptability.
And when you think about it, Starfleet would be able to use the strengths (and cover the weaknesses) of its officers VERY well. There literally thousands upon thousands of postings, between planetside, station, and starship postings. Got an officer that shows a great deal of expertise in hand-to-hand combat and crowd control, but showed no interest or expertise in the sciences and very little in technical areas? Security section of an open-port, commerce-oriented starbase deep in Federation territory. This would mean that not only does Starfleet function better as a whole due to this diversity, it also can afford to be very accommodating when it comes to individual officers requesting certain types of postings, at least in peacetime.
Because being violent is easy, it's not rocket science, never has been.
That's actually really insulting to anyone who has devoted time to becoming good at some form of combat. You do realize that to be good at fighting - whether that refers to hand-to-hand, with melee weapons, with firearms, or large-scale unit or ship tactics - takes
skill, right? You can't just learn enough to throw a few punches, then assume you will be able to handle anything that comes your way. In the context of Starfleet, there's going to be a basic, minimum level of training for any officer that graduates from the academy as far as tactics, self-defense, firearms, and other combat-oriented areas (though I could see the minimum training for academy-graduated officers being much more extensive than that for enlisted personnel who do not have a security specialty), with some going beyond that minimum (possibly quite far beyond) depending on their specialty, focus, any prior experience or training they might have had, etc. This wouldn't overwhelm the scientific and technical parts of the curriculum, but would absolutely not be dismissed as "not so important" if Starfleet is the agency called upon to defend the Federation.