The Specialized Rockhopper (now called the Taho) is a very comfortable shoe... excellent for wearing all day. Looks fairly normal, doesn't have any crazy lugs like some mountain shoes, and the cleat fully recesses to eliminate any 'click' while walking.
Although... I've always wanted a pair of the Shimano SPD running shoes, called the FN-01. Sure, it's a Spinning shoe, but it looks comfy as hell. Alas, Shimano doesn't make a 49...