The whole string tension thing is relative. I've been into it plenty over the years.
I find it more important to keep as near relative tension across the fretboard as possible. Even to the point of trying Zachary strings.
It's far better for intonation and neck tension. After all you don't want the truss rod trying to counteract high tension treble and low tension bass strings. Truss rods can't really do that. It's why you'll often find a guitar neck gives more relief on the bass side than the treble side.
So whatever gauge you use you can set the neck relief to suit. But you want the tension as balanced as possible across the strings. Gibbons and King both use .008's on their Gibson's don't they?
Anyhow being a lifelong Fender player who uses .010's. I thought I'd struggle like hell with my LP and .009's. It felt ok when I tried it before buying it, could do better. But can't they all? As soon as I got home them things came off and a set of .010's went on. Well that lasted all of half a hour. They did not suit the guitar at all. I got the neck right but couldn't seem to balance the bridge to stopbar tension out, it felt horrible So I went back to .009's. I couldn't get them feeling right either, over the course of four months. Eventually I tried a .009-.046 set. Everything seems hunky dory now.
I still like .010's on my Fender's, despite the higher string tension because of the extended scale length.
Horses for courses.