I don’t personally find any Shimano hoods comfortable. SRAM all the way whose hydraulic hoods are also bulky and fugly (at least they were in the summer when I specced my Ti)
I think you're right about the SRAM ones, I haven't seen any that aren't bulky and my hydraulic Rival STI's aren't exactly pretty, but they do get the job done.
Interestingly Shimano have picked up on this with their new 105 group as they have a specific version of the hydraulic STI for small hands, here's a quote from the Cyling Weekly review:
"There are also new ergonomically shaped hydraulic dual-control levers (ST-R7020) that look identical in design to Ultegra levers with a greater range of reach adjustment for different hand sizes.
The customisability doesn’t stop there: 105 R7000 offers a separate version of the hydraulic brake/gear lever (ST-R7025) specifically for smaller hands, which is angled closer to the bar with more of an outboard position to avoid interference with the drops during operation. There is no separate smaller version for the rim-braking 105 STI."
Full write-up here https://www.cyclingweekly.com/news/product-news/shimano-105-r7000-374634#PzgKdJhKJGtdBGRH.99