Where a single-family residence which is nonconforming with respect to one or more bulk or setback requirements is proposed to be enlarged by a horizontal or vertical addition, and such addition would protrude no farther into a required yard than the existing footprint of the building or existing building envelope, and assuming no other violation of a restriction as to height, stories or building coverage, the Zoning Officer shall issue a zoning permit therefor and a variance shall not be necessary. However, if in the reasonable judgment of the Zoning Officer the proposed addition would appear to be so large and/or so distinguishable by design as to substantially transform the character of the residence and the impact of the same on the use and enjoyment of one or more neighboring properties, an application for a variance shall be required. For purposes of construing this section, no substantial interest of the neighborhood or public shall be allowed to be substantially compromised for the sake of expedient procedure; nor, however, shall any reasonable and relatively insubstantial addition as contemplated herein be unnecessarily proceeded upon.