I've now got about 10,700 miles on my MS3, and have experience driving it both purely highway (Boston to Wisconsin, then Wisconsin to LA) and mostly city (LA). I had seen other posts like this thread mentioning the optimistic trip computer MPG, so I have paid attention. Here's what I've observed.
During pure highway driving (1-2 stops per tank), the trip computer is dead on, within 0.2 MPG. I was getting 29.8 to 31.0 doing 75-80 mph; 340-350 miles per tank wasn't a problem. My girlfriend's Mazda 3 2.0L sedan only got 29 highway during a road trip this summer!

Auto vs. manual perhaps?
In the city, I've been averaging just about 290-300 per tank, for an average of ~25 MPG, while my trip computer is saying 26.5-27.8. I too noticed the ~2 MPG optimism since moving to an urban area.
My theory is similar to chronus337 in that the stop and go part is what causes the difference to occur. Look again at the CUR MPG on the trip computer at a stop light. It doesn't read zero; it reads "--.--". Since it's not a number, it doesn't average it into the trip computer's average MPG. It basically ignores whenever you are at a stop. But since you are still burning gas, the calculated fuel economy will be better than actual.
Anybody want to time how long they have the engine running but aren't driving during their next tank of gas? Also, does anybody know the fuel burn rate at idle? Then we could figure out if my theory is true....
-Carl