We used to admire heroes because they were brave, perfect, noble and morally unshakeable. Today, audiences increasingly feel more connected.