I have solar panels on my roof. The were installed on top of regular roof tiles, since my house was already built by the time I was ready to install solar panels. But if you are building a new house, I think it makes a lot of sense to use Tesla Solar Roof. The roof looks great, you get clean energy and the warranty is for the lifetime of your house, or infinity (whichever comes first). From a personal standpoint, I wish these had been available when I built my house.
As for the gamle on Tesla/Musk part, I would say that this is a long term, strategic move. More an more energy will come in the form of electricity. The solar panel market is full of chinese panels to put on top of your existing roof tiles. But in the future, when the "normal" will be to generate your own electricity, people will want the cool roof that looks like a normal roof. Not then weird "add-on".