I think I was lucky to come of age in a place and time - the American South...
I certainly don't think you need to be famous to want to leave a legacy but when you are famous it's even more likely that your child will get the wrong perspective on your life if you die prematurely.