@JeffGrimesArt @JedDrudge @Morghur I've been struggling with this a bit myself with writing. Two things have helped me:

1. I'm a Christian, so I consider all creative endeavors to be practice for when God has me do larger projects after my time on Earth.
2. Many of my favorite authors are people who are and were unpopular, especially in the mainstream. Edmund Spenser, George MacDonald, Lord Dunsany, Clark Ashton Smith, and William Allen are only known in literary or very niche circles, but their respective contributions to literature are broader today than most people realize. Consider that the Beowulf poet, the Gawain poet, and the Rood poet are each anonymous, but their works are widely read by English scholars. Beowulf spent a good five centuries in obscurity before someone rediscovered it in a noble's personal library, and now it's often required reading for any serious English scholar. My point is that your work may not be recognized immediately or even in your lifetime. The point is to leave something timeless or fun or insightful for people to ponder and to look to for inspiration long after you're gone from this world.