It's really dependent on road conditions and riding style as well as rider weight.

Think about how you would adjust fully adjustable suspension. Rider weight is a starting point, but only a starting point. Then realize that your tire pressure is your ONLY suspension adjustment on a road bike.

The rider weight charts basically look at one thing only: what pressure will prevent pinch flats ("bottoming out") on average roads?

There's much more than that involved in suspension setup, obviously - rolling resistance, braking and turning performance, comfort and handling over particular road conditions, tire wear, etc.

I'm 120#, I ride probably average roads (a fair amount of chip-seal, but not a lot of cracked/potholed asphalt), and I prefer my 120# max 23c tires at 115psi. Anything below 110 I really notice the increased rolling resistance. I have a cheap-ish carbon frame, so that does soak up some of the vibration that someone on an aluminum frame would have to rely on their tires for.