I did misjudge it once: I was living in a different country with two fellow Irish people and the relative of a good friend died. In Ireland it would have been expected that we attend the funeral, in this case we showed up and there were only six closest relatives there, and our presence just felt inappropriate. I now know your place at a funeral is about your place in a wider community. That often overlaps with being a connection-of-a-connection, but not always.
Also, your intentions are to be commended regardless of what the relatives thought (it's not the relative's funeral, so they are not the yardstick).
The cherry on top was our youngest started getting restless during service and we had to leave early and we didn’t sit in the back.
I had only been to my parents funerals at this point, and never experienced a more formal religious service, but we were the worst in so many ways. I still regret it 10 years later.
Attendees of a funeral make an effort to pay their respects to the deceased and to express their condolences to the family left behind.
Sounds extremely awkward and like a plot Michael Scott would get himself wrapped into.
As my grandmother liked to repeat: "If you don't go to someone's funeral, they won't come to yours."
[0] https://www.breakingnews.ie/ireland/crowd-shows-up-to-funera...)