I will give you some pros and cons, but as for the question of long term investment, this should be decided between you and your hired realtor after due diligence.
When I first saw Madrone, I was impressed by the low rise development in an up and coming neighborhood with the future site of huge UCSF Hospital and current and future life sciences there.
I am still impressed by the development, but there are things to consider (since you have already gotten a lot of pros from others, I'll just skip to the cons):
The development is built upon landfill that used to be an industrial site for many warehouses and such; the good thing is that new developments are seismically better designed than older buildings.
Also, you should look at "superfund" sites in the environmental hazards reports for the general area.
I like the outdoor swimming pool (this is one of the largest, if not the largest outdoor pool in SF), but this swimming pool would be used for only two month out of the year at most (this may be an expense issue with the HOA'S, but then many don't care).
Renters will pay a premium to rent at Madrone, but it will only attract certain types of renters; others will be turned off by not being in the center of the city and the vast construction noise going on.
Since it is a condominium and a new develpoment, it is not subject to rent or eviction controls; but, as you may know, all evictions in California have to go through a court process or jury trial.
I think it would be best for you to see if this development is a good fit for you; it is a good fit for some people and not a good fit for others.
Peter T. Chin 01866332