For my town bike with Schwalbe Silento IIs I inflate to the max which is 60psi. For my road bike I put in about 110psi which is a lot lower than the max of both the tyre (140psi) and the rim (12psi).
Generally harder tyres will have lower rolling resistance and be more puncture resistant; softer tyres will have greater rolling resistance but therefore more grip also, and they may be more comfortable. Personally I find hard tyres more comfortable than soft tyres, though. I hate to feel any "give" in the tyre either from the road or when cornering.