Even the biggest bands only have 5% of their songs be huge hits. For any creative endeavor you're going to have some whiffs. The ratio of whiffs to hits probably depends on the nature of the medium.