The promise of a nine-figure payout may be alluring, but even for most big-name creators, it's hard to achieve.