I don’t find any of the hand positions on drop bars comfortable in the least of ways. The hoods hurt my hands and wrist, the tops are too narrow, and the drops are only doable for very short durations. However, I like the appearance of drop bars.
Conversely, all the flat bars on my mountain bikes are perfectly adequate even for my longest 200-mile rides and I much prefer trigger shifters over “brifters”.