I have a couple of examples that come to mind for me on this.
Altered Carbon made me realize how horrible immortality would probably be for the world (I won't go into much more detail here to avoid spoilers. short version = the rich are immortal).
Star Trek: The Next Generation (and most of the Star Treks) made me so hopeful about the possibility of the future, and will always be a favorite of mind.