The Naboo state funeral was so much more effective and emotional than her passing on the delivery table. And I did really like the little, subtle touch of having a fake pregnancy "bump" on her body so that her family and others believed she died before giving birth, helping cover up the existence of the twins.
Lucas does death better than birth. Yes that was a good scene in itself.
I guess really a lot falls on the character of Anakin being so uncharismatic and the romance dialog being so atrocious. It's not that I can't see Padme with a bad boy, it's just this bad boy is lacking any appeal at all to the viewer. So even setting aside that it is totally out of character for a woman of Padme's strength and life of selfless devotion to duty to die of a broken heart it is just plain hard to choke down that it was for Anakin in the first place!
Just imagine she was in love with Obi Wan and Obi Wan died.. she would be all "Obi Wan would want me to raise our children and I will honor his memory and raise them to know how wonderful and strong their father was.." You can't even imagine her giving up if the father was Obi Wan and he was dead.