I've been working on my site:
https://golfcourse.wiki for some time, and this is exactly how I feel all the time. Thank you for the encouragement.
I know this is a good idea. I know it will help people. I know I can either monetize it long term or even have it function as a non-profit. I also know it will take many years to slowly build to the functionality and content quality that I'm aiming for. Holding onto that long term view is extremely challenging.
Most days are just watching nothing happen, or slowly, slowly adding a single course (aggregated sites litter the golf internet, I want the opposite). One day I'll post on the golf subreddit and have 1000 users, get positive feedback, and the next two weeks just 5 users per day from google. And the kicker is, I'm genuinely embarrassed by some of the sub-optimal code and real lack of functionality I haven't addressed, even though I'm honestly very regularly working on it.
The best advice i got from a friend: only look at one-month or two-month increments as far as users. Day-to-day can get depressing, but on a bi-monthly basis, I've had slow-and-steady growth. At the same time, while I'm only up to 700 commits so far (vs 2000 in the article), I do have serious anxiety that I'm wasting years of my free time building something that won't amount to anything but a couple hundred upvotes on reddit, so I look at it as my unique hobby. I like mapping courses and making course books. It's my site and my hobby, and I'm fine if it's just me doing the work alone for the rest of my life. I believe that much in the project.