"Significant" is pretty subjective overall. In the end, there will always be critics to whatever you do. People in the US have been brainwashed into thinking people like GW and Christopher Columbus were good people until people connected the dots and realized they were in fact not. I won't be the one to cure cancer or end war in my lifetime, but the most I can do at this point is to give someone else hope.

Just being a role model for someone or treating someone like a human being is still significant if you think about it. People get attached to the romanticized idea of being hailed a hero for something "significant" that happened, but usually being that kind of stereotype involves a type of sacrifice. This is why comic book heroes usually have tragic back stories. It is not so black and white.