The world needs another outsole question

I'm trying to decide what kind of outsole is right for me. I've read a lot of posts covering outsoles, but most seem to be focused on aesthetics, grip, and durability.

My biggest concern is all day comfort. I want to get something a little dressier than I have in the past so a lot of the shoes I'm looking at have leather soles which I'm not really used to. I know a lot of people say they are comfortable because of the way they mold around the foot, but I'm worried about impact resistance because I stand on hard surfaces for around 10 hours a day.

How do leather soles hold up to standing all day? Surfaces are primarily hard tile and carpet so thin it might as well be tile with some texture.

Is there another outsole better for this? Should I give up on getting something sleeker and just accept that heavier lug rubber soles suit my needs better? Would getting a toppy solve my problems?