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.