I had a similar issue when I was in a wedding a couple of years ago. I have crappy feet that are wide/Doublewide with planter fasciitis. I can only wear comfort shoes or superfeet insoles. I tried so many different things and finally settled on these sandals. They are so comfortable! And although they are not the typical shoes you would wear for a wedding, they do have some bling on top so I think they’re dressy enough.
https://www.shoemall.com/product/dav...n-s-/1093571-1
Heck, I even took a pair of gold fit flops for the reception, in case these were too much for me. I had a floorlength dress though.
Another option is to find a comfortable insole and insert it into another shoe, though that can be a little tricky with dressy shoes.
"Friendship is born at that moment when one person says to another, "What? You, too? I thought I was the only one." C.S. Lewis