Is it permissible to offer mandatory prayer while sitting?
All perfect praise be to Allah, The Lord of The Worlds, and may His Peace and Blessings be upon our Prophet Muhammad and upon all of his family and companions. Standing up is a pillar in the mandatory prayer and the prayer is not valid without it unless one cannot do it. As for Nafila (supererogatory prayer), one can perform it in the state of sitting even if he/she can stand, but his/her reward is half the reward of the person who prays while standing if he/sh has no legal excuse for such an act. And Allah Knows Best.
What is the ruling on bypassing a nearby mosque for a distant one?
Praise be to Allah, and peace and blessings be upon our Master, the Messenger of Allah.
If a distant mosque has a larger congregation (Jama‘ah) while the congregation in the nearby mosque is smaller, and the congregation in the nearby mosque is not adversely affected by the worshiper's absence, then it is better for him to pray in the distant mosque with the larger congregation. However, if the congregation in the nearby mosque would be affected by his absence—such as if he is its Imam, or if his presence encourages others to attend—then praying in the nearby mosque is better. This ensures that the congregation is established in two different locations within the community. This is based on the saying of the Prophet ﷺ: 'A man's prayer offered with another man is purer than his prayer which he offers alone, and his prayer with two men is purer than his prayer with one and if they are more (in number), it is more beloved to Allah, the Mighty the Majestic' (Narrated by Ahmad, Abu Dawood, and An-Nasa'i). And Allah the Exalted knows best.
What is the ruling of Islamic Law if the follower (maʾmūm) stands up for the third rakʿah out of forgetfulness while the imam has sat for the middle tashahhud?
All praise is due to Allah, and peace and blessings be upon our master the Messenger of Allah ﷺ.
If the imam sits for the tashahhud while the follower (maʾmūm), out of forgetfulness, stands up for the third rakʿah, he is obliged to return to his sitting position, since following the imam is obligatory. In this case, no prostration of forgetfulness (sujūd al-sahw) is required of him. If, however, he fails to return, his prayer is rendered invalid.
Shaykh al-Islām Imām Zakariyyā al-Anṣārī, may Allah have mercy upon him, states: "If the follower stands up alone out of forgetfulness, he is obliged to return, since following the imam is obligatory... If he does not return, his prayer is rendered invalid, due to his departure from what is obligatory." [Asnā al-Maṭālib,Vol.1/P.190] And Allah the Almighty 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.