> I find it endearing that our visions of the future always see the best (or worst) of humanity, but never the mundane or banal.

Because the banal makes for boring stories.

Star Trek could just as well have been set aboard a naval ship island hopping in the pacific or similar. Being crewed by the best and brightest of their generation, and equipped with the latest science had to offer.