I have a collection of books for CTOs on my website that you might enjoy: https://www.briansnotes.io/audience/cto/

The Manager's Path is another I highly recommend. That book provides the most detail I've seen about the career path to CTO and changing expectations along the way.