Weird. The most lively guitars I've played have all been bolt on.
When you're talking about sustain, how long are you holding notes and chords for? Every guitar I've ever played that was properly setup has been able to sustain single notes for more than 8 seconds . . . and I don't think I've ever had to hold a note for that long while playing a gig.
I'm really talking more about the way you feel a guitar come alive in your hands when you play it.
And the way its character changes at volume.
I see two rather different elements when evaluating sustain. There's the guitar's inherent natural sustain, when playing quietly or unamplified.
Then there's the aspect where a guitar - especially its neck - resonates with the strings and with the ambient sound energy in a room.
I think of this as its live sustain, since it's tied to liveliness of feel. For me that's a very important quality in a guitar.
IME mahogany necks generally have tended to come alive more easily than the more rigid maple or extra-stiff multi-piece laminated ones.
(That doesn't mean stiff guitars won't sustain, of course, just that they normally require higher volume before you can feel them really wake up.)
But even in hard maple, my set-neck Fenders feel more lively - and may have slightly better inherent sustain - than most of my other Fenders,
IMO though, the particular pieces of wood often can make more difference to the feel than species or construction details.