You would get timing boost, fuel distribution and pressure boost, tranny pressure boost and shift points changed, rev limit and top speed limits removed, and more. The tune really changes the way they run and, I feel, for the better!
My "Pocket Rocket": '05 Silver Metallic Escape XLT, 3.0L V6, 4X4, MAC SRI, custom 2-1/4" catback w/turbo muffler, SCT XCal3 93 octane ECU tune, approx. 240 hp, 4X4 fuse pulled (rice humiliator)
Wife's: '08 SES, Airaid SRI, no resonator, SCT tuned