I personally like them for really long rides. On a flat bar my hands go numb and there are only so many different ways you can hold a flat bar. Properly fitted drop bars at least give you more options to switch up your grip and posture.

Can they get uncomfortable? Sure, but any position is uncomfortable if you hold it long enough.