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 prayer mandatory on a dying person who goes through a state of unconsciousness, then wakes up?

If he wakes up and was conscious, then he should pray the way/manner he could, but if he wasn't, then he is exempted from obligatory prayer as Allah Says in this regard (What means): "On no soul doth God Place a burden greater than it can bear." [Al-Baqarah/286].

What is the ruling on a woman driving a car?

All Perfect Praise is to Allah, The Lord of The Worlds, and may His Peace and Blessinsg be upn our Prophet Muhammad and upon all of his family and compnions.

It is permissible for the woman to drive a car, but it is impermissible for her to travel unaccompanied by a Mahram (Unmarriageable kin). And Allah The Exalted Knows Best.

What should a worshiper who has forgotten a pillar of prayer do?

If he/she remembered the forgotten pillar before offering it in the following Rakah (unit of prayer), then he/she should offer it, and continue the prayer, then offer Sujood As-Sahw (Prostration of forgetfulness) at the end of it. But, if he/she remembered that forgotten pillar after having offered it in the following Rakah, then he/she should offer a new Rakah in its (the one in which he forgot a pillar) place, and offer Sujood As-Sahw.