There will definitely be places where its considered a detriment and not an asset, for a variety of reasons. Some may not like the visual aspect of the panels on the home (definitely a thing), and others it could be seen as... well lets just say that everything can be politicized whether its warranted or not.
As far as resale goes, I kind of think of it similar to a pool, currently. In some places having a (inground) pool is a benefit, in other places its neutral, and in still others it would be considered a negative. For some people, a pool in the backyard is a non starter (I am one of those people actually), regardless of if its "desirable" in the neighborhood or not.
What I believe will eventually happen, is that PV will go from being the equivalent of a pool, to the equivalent of a kitchen remodel, which in general is usually net positive, and in some places can raise value more than it cost to do.
I dont think we are there yet, personally, but we will be, especially in CA, sooner rather than later.