are the specialized body geometry shoes any good?
Yes they are. It would be beneficial if you could get to one of their concept stores to get a proper shoe fitting.
I had a similiar experience to you over the weekend, feet were in bits after only a few hours of a big event. I loosened straps, changed socks, tried to pedal differently but nothing worked. I have come to the conclusion my Sidi shoes just don't have enough cushioning for me for longer events. Out last night in my old spesh shoes with no issues. I too have flat feet.
Apparently it's all to do with the metatarasal area.
Have a look here.