I think the tributes were vastly overdone, and I've not watched much of the funeral, however I have a lot of respect for the Queen, and it is obvious from some of the photos that he was a great support to her in a life I wouldn't wish for in a million years.
Being rich isn't everything, every aspect of their lives is picked over, every flaw exposed, every family rift (real or imagined) makes the headlines.