I'm a small guy myself. But I always wondered how much that really affects my taste in neck profiles.
My second guitar was an Epiphone Les Paul Speciall II which had a profile close to the Gibson Rounded 50's. Chunky, but not '58 kinda massive. I always thought that was kinda like the definitive neck profile. I mean, I always wanted a Les Paul since I first started guitar, and that was my first Les Paul. My first guitar was a Yamaha Pacifica which had a thinner neck, IIRC.
But then I started getting nicer guitars, and the nicer the guitar got, the thinner the neck profile. The nicest guitar I've ever owned was an Ibanez RGA121 (which, I mean, is nice, but it's certainly not top-of-the-line Custom Shop stuff) which had the Wizard Prestige neck. Really thin. I then got an RG570 which had an even thinner neck, but I always preferred the RGA121's neck probably because I preferred the guitar overall.
A few years after that, I got my first Gibson Les Paul. Like I said, I've always wanted a Les Paul. The guitar itself is great. It's the best-sounding guitar I've owned. But the neck is... tolerable. I mean, I can get around on it. I like that the fretboard at least is not round like a Fender. But man, I really wished it had the 60's neck. And the thing is it's not even uncomfortable. At some point, I thought it was even pretty nice, but I was comparing it to my Epi 1959 which had a slightly chunkier neck with the clunky D-shape Epiphone are known for. But now that I play it alongside my Fender with the Flat Oval or my LTD with the Thin U... It's just not the neck I'd want on my Les Paul.