Methods comprising: introducing a micro-proppant treatment fluid into a formation at a rate and pressure sufficient to create or enhance at least one fracture in a first treatment interval, wherein the micro-proppant treatment fluid comprises a first aqueous base fluid, micro-proppant particulates, and a first aqueous-based surface modification agent (“ASMA”); placing the micro-proppant particulates into the at least one fracture; introducing a surface modification treatment fluid into the subterranean formation, wherein the surface modification treatment fluid comprises a second aqueous base fluid and a second ASMA; coating at least a portion of a face of the at least one fracture with the second ASMA; introducing a macro-proppant treatment fluid into the subterranean formation, wherein the macro-proppant treatment fluid comprises a third base fluid and macro-proppant particulates; and placing the macro-proppant particulates into the at least one fracture.