Homeowners in some of the largest U.S. cities can get a better return from rooftop solar than from a pension fund or the S&P 500, a new study found.