@Ranger Ray you are right there are some movies that have engineers in general (Apollo 11 comes to mind as well), and I'm sure there are a few times logistics comes up generally when it becomes critical.
I think if you look at entertainment in general support never really comes into it when things are going well, but when you outrun the supply lines, things break down etc then it becomes part of the story.
No real difference than sports though; pretty complain joke in rugby that the wingers get all the glory for taking the ball the last few yards to score, and the 80 yards of work by the forwards gets forgotten. On the Navy side doesn't matter if you provide power/propulsion/hotel services 364 days a year, people will still be pissed off the one day they get a cold shower.
All totally off topic I guess, but I guess going back to the warrior example, the knights got all the glory, and the squires, baggage train and supporters they required to actually do things gets totally ignored (unless their armor got forgotten or something). People get similarly enamored by the Spartans but miss the bit that to have a standing army of professional warriors they needed a standing group of slaves/servants to do all the farming and other routine stuff that makes societies actually function.
I'm personally happy to let other people be the pointy end of things (especially as I get older), but it's a bit more obvious and directly observable on the Navy side how quickly the pointy end goes from being combat capable to less functional than a fishing boat without support, so maybe less of an inferiority complex from the RCN/RCAF side of things compared to a service battalion.