When I was younger, I believed that heavy guitar = good sustain (that what the Gibson owners are saying ...) but in fact it's completely false. My Axis is very light and has an incredible sustain.
Yeah, it's a complete myth, if anything I think lighter guitars may sound a bit better.