Super Mario Galaxy 2 is my favorite game of all time, toppling Super Mario World. I've always wondered how nintendo can top Galaxy 2 in their next Super Mario entry. Nintendo would have to create a game on a smaller scale ala 64 and sunshine. I have no idea if it is possible.
In terms of future titles, perhaps a future Pikmin game, borderlands 2, Monter Hunter 4. Really any game that has amazing gameplay, fun factor, and captures me at the right moment has a shot.