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 person who broke fasting in Ramadan because of being sick to pay a ransom?
If there is hope for him/her to be cured, then he would be required to make up for the missed fasting days when he/she recovers, and no ransom is due on him/her. If his/her disease is incurable, then he/she would be required to pay a ransom for each missed fasting day, which is (600) grams of wheat, or rice. And Allah Knows Best.
Is it permissible to offer an absentee funeral prayer?
Yes, it is permissible to offer an absentee funeral prayer.
What is the ruling on reciting verses of the Holy Quran on water, then drinking it?
It is permissible to recite Quran on water, then drink it as a kind of treatment since the Quran heals. Allah, The Almighty, Says (What means): "We send down (stage by stage) in the Qur’an that which is a healing and a mercy to those who believe: to the unjust it causes nothing but loss after loss." [Al-Isra`/82].