Everyone can build something new and shiny on the green field. If it doesn't work out you can always find someone or something to blame, because what you set out build was an awesome, highly innovative[1] endeavor anyway. Moving on to something else new and shiny after a while is not only ok, it is expected. Sticking to something, through good and bad times, on the other hand, that's not something many people can do,…
You're examples have very little to do with an average org's IT projects. Not in scope, definition of 'success', or definition of 'finished'. If you're company is building a programming language or operating system you need to make sure that is what you love doing.
Also perseverance is not the same as being stubborn and pivoting is not giving up.