Lurvvvv! (Hadith No. 1170)

Narrated 'Aisha:
During his sickness, Allah's Apostle was asking repeatedly, "Where am I today? Where will I be tomorrow?" And I was waiting for the day of my turn (impatiently). Then, when my turn came, Allah took his soul away (in my lap) between my chest and arms and he was buried in my house.
Prophet (SAW) would take regular turns to be with his wives. Although he loved `A'ishah (RA) more than the others, he never treated the others unjustly. During the days of his fatal illness, he became really impatient to be with `A'ishah, so he would ask again and again: 'where am I today? Where will I be tomorrow?', indicating that he wanted to visit `A'ishah real soon.
And same was the case with `A'ishah (RA); she kept getting impatient as well. So in order to fulfill Prophet (SAW)'s wish, the wives mutually decided to let `A'ishah have their share of the days. When finally he came to be with `A'ishah (RA), it was there in her lap that his soul was taken away. And it was there in her house that his body was buried. Sallallahu `alaiyhi wasallam.
When you love someone, it's natural that you desire to see them and be with them as much as possible. And with a love so pure as this one (among spouses), it's just plain cute. <3
The last person Prophet (SAW) saw before his death was `A'ishah (RA). Aww! :)
One of the greatest aims of marriage according to the laws of Allaah is so that affection and compassion may prevail between the spouses. This is the foundation on which married life should be built. Allaah, may He be exalted, says:
“And among His Signs is this, that He created for you wives from among yourselves, that you may find repose in them, and He has put between you affection and mercy” [al-Room 30:21] 
Al-Haafiz Ibn Katheer (may Allaah have mercy on him) said:
Affection means love, and compassion means kindness. A man keeps a woman either because he loves her or her because he feels compassion towards her because he has children from her.
Ibn Katheer (may Allah have mercy on him) also said: 
There is no love between any two souls greater than that that exists between the spouses.
Tafseer Ibn Katheer, 3/525
Difference between love and 'madness' here.