I would always go to a funeral if I could.
The first funeral I went to was my grandfather's and was awful, as it was only his children and grandchildren. (I would live to know the internal family politics that happened there - we have a large extended family, and I don't think it was right to leave people out, but I was 10 at the time, and I've only wondered this as an adult.)
A big funeral is better, IMO I've been to quite a few in South Wales, too, as I have a lot of family there. My father used to go to quite a lot of funerals (it seemed) - he would go to local farming one's to represent the farm.
I have been to some very uplifting funerals. I sort of enjoyed both of my parents' funerals, in that they were both totally right for each parent, and it half expected to look round and see them there. It helped that for Mum, she had always talked about a particular piece of music she wanted. If you do have clear ideas about how you want your funeral to be, do communicate it. It certainly makes it easier for those organising it.
A good funeral is uplifting and honours the person who has died. I have learnt interesting things about my people from eulogies. I was very touched by some of the comments at each of my parents' funerals, which showed what they had meant to people, and remember the comments still.
The funeral director dealt with putting notices in the papers, local and national - we just agreed on which papers and the wording. I mostly find out about people who I used to know at home from my sister (who is still local) forwarding me the death notices in the local paper (there are times I wish she'd send something else!)
A funeral is an important rite of passage. No one is obliged to go, buy I find them a helpful ritual.
BTW, if you want to leave your body to science, you can't just leave it to your children to decide when you have already died, which someone upthread said - you need to have agreed and organised yourself when you're alive.