There are pretty much two style profiles for SGs. From '61 until sometime in mid '66, they had a wide fingerboard that was usually around 1.68-1.70" wide with a slim profile. It was very thin at the nut.
Sometime in '66 after some of the changes to the heel, the nut was narrowed to 1.625", and the neck itself had a much rounder and thicker profile. My '68 SG Junior has a neck like a baseball bat. From '66 nothing really changed until the mid eighties or so. When Gibson finally started to listen to customers, they started introducing models that were close (but not enough) to what people wanted. It wasn't until the late 1990s or 2000s that Gibson put half the effort into SGs that they put into Les Pauls. With smaller hands, you'd probably like the profile that's on my '69 Standard. Even though the neck has a certain amount of roundness or heft, because the fingerboard is narrower it fits comfortably in one's hand.
But then, I like to fret with my index and middle finger behind the slide, so the wider fingerboard is better for that sort of stuff.
One of my '69 Standards was always my go-to slide guitar. It had the same power as the Les Paul I liked to use, but with easier high fret access. My Firebird was my other favorite slide guitar for the same reason. You could easily slide up to the middle of the pickups without any real efforet.