Spiked solutions for Schrödinger systems with Sobolev critical exponent: the cases of competitive and weakly cooperative interactions