I've had triangle pedals for 20 years. Look Delta, Keo, and SPD-SL depending on the year. I never complained.
My gravel bike and pedicab had SPD. I like being able to walk but I've never considered them as good on the open road.
I just recently switched to Speedplay. I have a kid due anytime and it's been super hot, so I've only gotten 2 short rides on them. So far I like the adjustable float and dual sided entry. Something seems off about my right leg but I don't have them dialed just yet.
As a general rule, think road shoes and pedals for riding as long and fast onbthe road as you can. Not for walking. Not for potty breaks.
SPD or similar, coffee shops, walking sections, and foot dabs are all ok.