Going through the same dilemma myself. I borrowed a 328i for the weekend and got 25 mpg with the eight speed auto. Quite a difference from the late 30s I get from my 330d.
Great engine the 328i and I think it would work well in the MSport car with a manual box.