I own several mahogany solidbodies (gibson), one maple semi-hollow (washburn), and several all maple basses (spector) - I think sustain has more to do with overall design and construction techniques more so than wood types so long as we're talking quality wood all around
tonal characteristics, well that's another story...
aside from just the wood, much of the perceived sound differences will be due to overall instrument design, pickups, onboard electronics...how everything adds up so to speak - my spectors are all maple and exhibit resonance that's felt as much as it's heard