I think these kinds of questions are great, they provoke introspection.. I don't think it's good to just float and live one's life, but I also think being so focused on a goal that you miss life entirely is also a mistake.
But I think some introspection is very good, there are times when one has to make conscious changes to their lives to make things better.
Personally, I'd like to be remembered as someone to be feared and awed.
Barring that, I'd like to be remembered as a good dad, and as someone that made a difference in a few people's lives.