Find an independent shoe store with a good rep and get fitted. I did it 3 years ago and haven't had a problem since. I go at least once a year and "my shoe guy" tells me which shoes will work best for my feet. I have freakishly narrow feet so I wear Danskos but only the narrow ones. He also tells me which NewBalance sneakers are best for my feet.
There are a lot of fashionable looking comfortable shoes out there but they tend to be expensive. Be ready to spend...it's worth every penny.
A friend of mine swears by Aravon shoes and sandals. I'm going to check them out when I visit "my shoe guy" next.