I have been to several humanist funerals. All very moving except for one which was not well conducted and rather awkward. I think that was partly due to the family wanting as little fuss as possible and partly the fault of a not-very-good celebrant.
The celebrants are usually from the British Humanist Association and the others I've seen have been wonderful, particularly one who conducted the funeral of a young man who had taken his own life - such a daunting task, but she was amazing, emphasizing many positive aspects of his life.
Of course religious funerals are often moving, especially when they are celebrating the life of someone who had a good long life, but sometimes they can seem to be all about God and not much about the late departed.