One, it's a red herring as you say, though I'd put a slightly different spin on it. Cobb has chosen his reality, he's had his catharsis and made a very intentional decision to let Mal go. That's true regardless of if the ending is a dream or not.
Two, it's an intentional denial of catharsis for the audience. It's a setup without a payoff, tension without release. Here's the interesting part about that- the audiences I've seen it with provide their own physical catharsis, their own reality-based relief of tension, by laughter or by applause. These physical reactions both release the real physical tension that has built in their bodies and also returns them to the real world, outside of the filmic dream.
Three, it captures the feeling of a certain kind of dream. How many times have you dreamed of almost having the answer, of almost knowing something you want to know...and then abruptly waking up? Yes, exactly.
It's the best ending shot to a movie in quite a long while.