SGs are wonderful guitars; for me, their necks are even more playable than Stratocasters and Telecasters. Many, if not most, people don't realize that Gibson's sold more SGs than the iconic Les Paul. Freebird was played on an SG (with a slide). Pete Townsend often played an SG and took advantage of the long neck - instead of using a tremelo, he'd just push or pull on the neck to bend notes.
Eric Clapton's famous guitar "The Fool" (which he played with Cream") was a SG:
The classic SG is the red stained model.
Frank Zappa, Jerry Garcia, Jimi Hendrix, George Harrison, all played SGs at one time or another - Zappa much of the time.
It was the guitar of choice for much of early heavy metal. AC/DC's Angus Young, Black Sabbath's Tommy Iommi.
Of course, all guitars have their places. I don't want to slight Les Pauls or ES-355s, or Fender Telecasters or Stratocasters, or Rickenbacker 360s, 360-12s, or 381v69s, or Gretsch Country Gentlemen, or '65 Epiphone Casinos . . . but the electric guitars that sit in the bedroom are a SG and a Telecaster. The rest are in the basement.