I think it's about finding a balance. What's the point spending every day at work building your 'legacy', all them late nights etc. When you die everyone will remember your legacy but not you. No one will miss you. But what's the point spending every day at home with your family, creating great memories with them and dying with no legacy to show.
The first point shows hundreds, maybe thousands of people will see what you left behind, be it code, art work etc, but you wouldn't have time to socialise, build a family and be truly missed by loved ones. The second point, you don't have much of a legacy but your family, friends will truly miss you and remember you. So, yeah, try to have both, or just one. It's up to you.