I had this problem on my droid, and still having it today on my Nexus. When I receive an MMS message, I get the notification, and when I go to view it, I see a download button. Clicking it makes it change to say "downloading" but nothing happens past there.
That's with Handcent AND the stock Messaging app.
That's with Handcent AND the stock Messaging app.