I am not exactly comfortable with the nature of this topic, but from an analytical media perspective...
Daniel Crag's Bond has all the refined elements of his predacessors, but the one aspect that his potrayal of Bond cranked up in CR is the characters humanity. Not just in making mistakes, but in his feelings. - The loss of Vesper affects him deeply, and strengthens the fact this Bond is not the full shilling through his ruthlessness. Through him we get to see that Vesper is indeed his equal on may levels, and the scenes of them together post torture are sweet and bitter - cause we know where its going to go. Although her sacrafice to save him is in part engineered though her betraying him, he genuinely feels pain at her loss. - Its clear how his attitude to women will develop. He won't let them get close, because he can't. Ever.
Having said all that, - the last time this approach was taken at face value, was in OHMSS. the film and its leading man have had detractors over the years. - I wasn't one of them. As Bond George Lazenby was convincing as a different Bond, and the scenes between him and Diana Rigg's Tracy sparkle. - Much as Craig and Eva Green's do almost 30 years later in CR. Lazenby gives Bond a vulnerability and sense or mourning that Connery never did, (his Bond was never written that way) and it makes his solo turn powerful, and memorable.
Honourable mention - In FYEO, at the start of the film, Bond visits his wife's grave. Sir Roger Moore does a lovely job of making this scene somber and sad, before the usual high octane chaos kicks in. Showing a part of 007 still feels the loss of Tracy deep inside.
In the real world, I personally have found that when you loose someone close to you, it never feels the same way twice. Relatives, Close Friends, its always an emotional roller coaster, and you don't know how you will react.