OP, here are my thoughts on this topic. Note that I do not have a solar roof, but panels. I do not have as much knowledge around the roof product as someone who has one, and we have several here that do.
With that out of the way... my thoughts:
The solar roof product itself seems to be good. There are no "real" competitors to the solar roof. Its real competition at this point is a regular roof with solar panels. Some other companies are working on things they call " solar roofs" but they are not that similar.
Tesla does NOT do well with trying to schedule things not on their own time... period. This will be close to the root of some of the complaints you will likely see from your builders. Tesla supposedly has a department that is now working on solar roofs on new builds, but I have my doubts on teslas ability to meet any kind of "regular / tight" timeline that a builder might box them into.
"Roof goes on at this week" is probably what needs to happen for your prospective builders, but I dont trust tesla to be able to meet such a timeline, possibly delaying your builder (and costing you money, since those resources are paid by the day).
If you choose a solar roof, you have to get " as much PV as you might ever want" up front, because adding to it will be virtually impossible. So, you need to build and get an accurate size for what you might need 10 years in the future.
Unlike a regular roof + solar panels, if you wanted to change out or add more powerful panels "later" 10-12 years down the road, with solar panels you can simply "take em down and put up new ones" not so much on a solar roof.
The aesthetics of the solar roof are very nice, if that look goes with your prospective home. the different colors etc have not been released yet, so the current color of the roof has to match what you are planning. Of course, if you are getting panels, they are going to cover up large portions of your roof anyway.
It boils down to "what is the driver for a solar roof"? for you. A solar roof will likely add time to your project, and be something your prospective builders dont want to deal with. If that is worth it to you for the integration, then perhaps its what you want. Solar panels are not as "integrated" looking, but have been around a while, and can be taken off and put up by a number of different companies, so you wont be married to one company / technology.
I think the solar roof has a lot of potential to be great, and am grateful for those who have taken the plunge to give their feedback. If it was me, and I was building a custom home, I would likely put on a regular roof and then get solar panels. I would also try to get the roof design to be pretty optimal for panels from a direction etc point of view as well as perhaps not seeing the panels from the street or something.