re: New construction exterior sheathing

Can't say I've ever seen or heard of it done like that. First impression is thats a lot going on with a wall assembly. Its not easy to find a builder (if you're going to use one) who is willing to do unknown things. They like doing things they are used to with no learning-on-the-job surprises. Poorly installed zip or wrap is going to suck no matter what. Also, with the cdx sandwiched between wrap and foam, I'm not sure there is enough ability to dry if water gets between them. Tyvek has decent permeability but a few inches deep open cell is very little perm. That plywood may be wet for a long time before drying. I just don't know.

My personal favorite wall assembly accounting for cost and performance is: generous roof overhangs then cladding~rainscreen~zip (or zip-R)~rockwool insulation. But there are many ways to skin that cat and new products are being put out every day.

Seems like you're thinking things through and want a well built home. I'd suggest spending a little money and time on greenbuildingadvisor. Not sure how familiar you are with it but they are more building science oriented than "green" which is a bit misleading. Once you've formulated a thoughtful idea of what you want, you can ask questions and get good answers possibly even from authors and industry experts who love talking building science. Just be mindful to ask good specific questions. Not, "so whats a good way to insulate a home" . Ain't nobody got time for that shite. Caveat; I haven't spent much time on there in 5 years so I think that's still how it works.