I don’t think this is true.
Opposition is not really related to aesthetics.
People fight even theoretical housing (zoning). NIMBYs oppose building housing on derelict / ugly lots. Architectural review is used by neighbors to stop housing - not because they’re preservationists - but for a load of unrelated issues and architecture is a convenient veto point.