I've seen a moderately serious treatment that suggests that in a fight between our modern military and the Enterprise, the modern military might very well win.
Seems the Reddit-originated movie-bound story Rome Sweet Romehttp://en.wikipedia.org/wiki/Rome_Sweet_Rome has a similar issue with the Roman military vs well-equipped (but no resupply) Marines gone back to that age. Modernity works up to a point, but eventually it takes "boots on the ground" with massive resupply chains to win.
Seems the Reddit-originated movie-bound story Rome Sweet Rome http://en.wikipedia.org/wiki/Rome_Sweet_Rome has a similar issue with the Roman military vs well-equipped (but no resupply) Marines gone back to that age. Modernity works up to a point, but eventually it takes "boots on the ground" with massive resupply chains to win.