I wanted to thank everyone for their responses. This thread spread off into some tangents I hadn't even thought about when I originally posted. Since there were some common themes as opposed to responding to each response individually I'll just try to lump it one post here.
As far building together as a father-son joint venture. I can see where others are coming from. But, it's a bit more complicated for us. I am at home with the kids so I already spend 40-50 hours a week around him. If anything we are often in danger of having too much dad+son time. And as with every child he has his gifts and he has his challenges so our individual time is often better spent on other life skills. And, probably the best argument against a joint building venture (at least at this point in time) is that my wife also agrees it is a bad idea.
To those who have shown examples of their kids creations and what has worked for you....many thanks. It has given me many options to think about. My kid enjoyed looking at the pictures/videos as well and it gave him a few ideas. One of those ideas after seeing both RohanBeckett's pneumatics and Sariel's hamster was to build a pneumatic hamster.
As to visuo-spatial reasoning and executive function. Interesting topic so it might be best if I first explain how we ended up where we did. In order to support skills such as delayed gratification, taking on challenges, focus and self control, and just plain having our kids finish what they started we setup our educational toys similar to what you might find in a Montessori classroom. Now our kids have plenty of objects/toys just to play with but our educational toys (of which I include the Lego Creator and Technic sets) we put up on shelves that they could easily see. And, we generally try to keep something they are ready for now up there as well as well as a few iterations into the future to look forward to. So, for instance when my son felt he was ready for the Formula Offroader he took it down but he could easily see the Arctic Truck and Crawler Crane next to it. And from time to time he would pull those boxes down, study them and then put them back up knowing he wasn't quite ready for them yet. Anyway sometime I think in November or so he saw the BWE on one of the Youtube Lego channels and started pining for it. I didn't commit really one way or the other because I really thought the set was just too big and by the time he was ready he might just not be interested in it anyway. But something lit a fire in him because in December he fired off the Arctic Truck, Crawler Crane, 10220 VW Bus and then ultimately the BWE. So you can kind of get a picture where that left me. In a very short period of time I was left with an empty shelf without a visual and touch and feel representation of what was next and no plan on how to reconcile that and move into a different direction. Hence, this thread.
Anyway, back to Visuo-spatial reasoning and executive function. My knowledge is limited only to what I have read but our son does seem to have some favorable combination of the skills required for executive function, as well as visuo spatial reasoning, and to some an extent maybe eidetic memory. And we do try to give him opportunities to use these skills in everyday life. For instance, we will often let him plan and guide our journeys across town using his working memory of the bus routes alongside his eidetic memory of the train map. Now, the main limiting factor he has with executive function is that his emotional regulation and frustration tolerance are definitely not up to the level of his other executive function skills (something he has no doubt inherited from his father). And this is something I do have to keep in mind with whatever challenge he chooses or I might suggest. But, it is quite possible that moving away from mainly visuo-spatial reasoning and towards executive function might well be the logical direction to go in his passion for lego as well. At least in his desire for a challenge. He does have plenty of opportunity to play with his legos and build freely but after a while he does crave the next level challenge as well.
As a final note, this journey with Lego has been quite amazing and unexpected. It's certainly been great for my eldest son as it's allowed an opportunity to follow a passion with skills he was innately born with. But even more amazing is how much it has helped my younger son with his focus and self control.