Fascinating question - define success.
I've told the story before: Frank Capra, who'd made a string of box office winners and garnered a number of academy awards basically walked away from Hollywood after the box office failure of It's A Wonderful Life. As he recounted in his autobiography, his confidence was shattered by the failure - he'd always deeply believed that he knew what "worked" for the audience, and when what he thought was a terrific film failed so badly he was unable to ever it that again.
And yet It's a Wonderful Life is seen now as a classic of golden age filmmaking and has touched the lives of countless millions.
I once tipped my hat here to Rene Muylaert, a virtually unknown Ontario architect from the 60s and 70s who built some 25-30 modest courses (St Andrews Valley might be his most famous, and maybe best, and more ambitious than most -- and he had a good site); no awards, little acclaim, probably not even much money....but many (most) of those courses are still here -- not being renovated, not being 'restored' -- and still providing solid affordable golf for thousands every year, after almost 50 years.