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.
Is it permissible to offer Salah (prayer) on behalf of the sick who is on his/her death bed, and is incapable of offering it?
It`s impermissible to offer Salah on behalf of the sick, or the dead.
What is permissible for the husband to do as far as having sex with his wife is concerned?
The couple are free to enjoy each other sexually provided that they don`t do it during menses. It is also forbidden for the husband to enjoy the wife from her anus.
Islamic creed is a comprehensive creed, and if there is any defect, the creed of the individual or group is not correct. Is the creed of the Sufis correct or not?
Sufism is the practice of applying knowledge; this is how Al-Imam Al-Sha'rani defined it. If some among them have deviations in creed, it is not permissible to generalize this to all Sufis, as there are those among them who are acknowledged by all scholars for their knowledge and virtue. And Allah The Almighty Knows Best.