What is the stance of Ahlus-Sunnah wal-Jama'ah regarding the historical figure known as 'the Sufyani,' who some say will appear at the end of times? And what is the stance of Ahlus-Sunnah wal-Jama'ah regarding the group that killed Al-Husayn ibn Ali (may Allah be pleased with them), particularly those who directly committed the killing, severed his head, and killed members of his family?
Most of the narrations about the signs of the Hour concerning the Sufyani, who is said to appear before the Mahdi, indicate that he is the leader of the army that will invade the Kaaba, and Allah will cause the earth to swallow them. We disassociate ourselves before Allah from those who killed Al-Husayn Ibn Ali (may Allah be pleased with them), supported his killing, or encouraged it, whether openly or secretly. The inner matters are left to Allah alone. And Allah The Almighty Knows Best.
Is it incumbent on a family to provide for its old handicapped son and take care of him?
The family and relatives - e.g. brothers - of such a person are obliged to spend on him and take care of him if he didn`t have money of his own.
When the soul leaves the body, does it hear and see? And where does the soul go?
The important thing is that the soul departs while its owner is a believing, repentant Muslim, as this is a good ending. As for the details, they are lengthy. The grave is either a garden from the gardens of Paradise or a pit from the pits of Hellfire. And Allah The Almighty Knows Best.
I can`t afford to get married, what should I do to curb my sexual drives?
You should offer a lot of voluntary fasting, keep busy with useful and permissible acts and make supplication to Allah, The Exalted.