> Is it just hard to maintain that level of enthusiasm over time? Is the sum of possible money just too desirable?

I do not recall the book/essay or the original author, but I recall the quote that “everybody has a price they can’t resist, find out that price…”.

If your enthusiasm product is successful and has potential to be milked, someone somewhere will figure out your price and eventually buy you out.