So sorry for your loss!
I have had two miscarriages. For the first one, I had gone in for a routine ultrasound at 9 weeks to confirm the pregnancy. No heartbeat. I was heartbroken, but I wanted to miscarry naturally. I didn't pass the baby until about three days later. I had bad cramping, but nothing bad enough to require pain medication. It was quite messy, and I pretty much spent a whole night on the toilet.
For my second miscarriage, I again found out at the routine ultrasound that there was no heartbeat. This was at 10 weeks. I wanted to avoid the D&C again, so I just decided to wait for the baby to pass naturally. After a week went by with no signs of any bleeding or cramping, I decided to just have the D&C procedure. I was already heartbroken about losing the baby, and I was still feeling the pregnancy hormone surges (including morning sickness).
The D&C procedure was totally painless. I was put under, and when I woke up, it was all over. I had minimal pain and bleeding afterwards. The doctor also told me that there was basically no fetal sac left, and it had pretty much already deteriorated at the time of the D&C. It only took me a day or two to recover physically. Moving on emotionally was harder.
Please be kind to yourself. And if anyone offers to make you meals or take care of your other kids, take them up on it! So sorry again. It's so heartbreaking.