GA it is indeed the time spent with the family, garnering all the anecdotes and personal memories, that makes for a 'memorable' service. My DD spends hours with the family, writes up the ceremony and delivers a copy to them for comment and amendments if necessary and afterwards delivers a beautifully presented copy to the family to keep as a memento.
The worst service I have ever attended was for my dear friend and political mentor, whose sister arranged the funeral by phone via an undertaker. It was at the Crematorium with the 'duty' minister, who quite obviously knew nothing about my friend and the 'duty' organist playing the stock funeral hymns. There was no mention of her career as a theatre sister, her lifelong devotion to the Nationalist Cause, her many years as a Councillor and Group Leader, serving her Community.
Instead we were treated to a bog standard 'She was a faithful wife and mother and servant of God', when in fact her biggest regret was that she was childless, though she did indeed nurse her DH for many long years. The minister did say 'wife and mother', then corrected himself without apology and said 'Wife'.
The crematorium was overflowing - over 300 folk there to pay tribute. No meal had been arranged to follow, so we stood about in the rain outside the Crematorium, sharing memories. Awful, just awful.