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.
Should a prayer performer who forgets to offer the middle Tashahod (saying ash-hadu anala ilaha ila-alah) offer Sujood As-Sahw (prostration of forgetfulness)?
He/she should offer two prostrations of forgetfulness at the end of the prayer. And Allah Knows Best.
Should a person feel pleased, or have a virtuous vision after offering Istikhara (guidance prayer) in order to do what he/she had offered it for?
The result of the Istikhaarah is not necessarily that a person sees something (in his dream), or feels pleased, but the most important result of the Istikhaarah is whether a person is enabled to do a given matter or not.
Is it permissible for a praying person to make supplication in each Sajdah (a prostration) of obligatory prayer?
It is permissible for a praying person, whether praying individually, or in congregation, to make supplication during Sujood (prostration) in obligatory, or voluntary prayers. However, it is disliked for the Imam to do so since he is required to spare the prayer performers any sort of hardship, unless he is leading a certain group who don`t mind him extending the prayer.