The weight of a fully loaded handgun is an interesting problem. Years ago. I would pop my 14oz loaded 340pd in a leather pocket holster and I was good to go. Retired, and took a job as an RSO/instructor and my work carry guns got larger and much heavier. Enter the P365 and the perfect carry weight for me and for the most part, if I am wearing pants, that gun is on me in one configuration of another. I have no aversion to the lighter guns but with them comes less capacity and in todays world, more ammo may be a good thing. As for full size high capacity, they now reside in my safe seldom used but not forgotten.
One word about support, I am tall and thin and I always carry AIWB. Years ago I switched all my carry belts to those from https://abetterbeltusa.com/. I have three in various colors of buffalo and after a decade they still look like new. Their reinforced belts will support a lot of weight and keep your pants up where they belong. Buy once, cry once but in my case cry three times
"Never pet a burning dog"