Years ago I took the Myers-Britt test and was an INTP. In the last year I picked up an art hobby (with a lot of coding skills) and have been doing a lot of reading and other work relative to art and relationships and I retested as an INFP. Now my heroes are people like Walt Disney and Jim Henson. I wouldn’t be surprised if I test as an ENFP a year from now.
I knew some CTO's that wrote the initial code (ergo, code quality totally sucked), or would write a 1-off extension (where the code quality didn't matter much). Once the company achieved some size (>5 developers) they just didn't do it anymore / it wasn't a quality use of their time.
As they matured, they tended to focus on the data schema and the soa architecture, and less on the bits and bytes of functions and frameworks.
What drives you to keep being the primary coder?
For me the trick is to just begin, no matter how small the initial step is.
I think what really triggers curiosity is the ability to learn new things while making an okay progress.