Does passing wind, from the anus without a smell, invalidate prayer?

If a person is certain of having passed wind even if it was with no smell, then both his/her ablution and prayer are invalidated, thus he/she should remake ablution and re-perform prayer.

Generally speaking, I`m dutiful to my mother and opt for obeying her. However, she chose a certain girl to be my future wife, but I`m not pleased with her choice although that girl comes from a good family and enjoys good character. Should I obey my mother or choose another girl that lives up to my expectations?

Praise be to Allah the Lord of the Worlds.

One must obey their parents in whatever is in compliance with the teachings of Sharia and within one`s capacity. However, you aren`t to blame for not marrying that girl, but it is better that you tell your mother about that and it is preferable that you perform Istikharah prayer. And Allah The Almighty Knows Best.

The supplication: "O Allah, we do not ask You to avert the decree, but we ask You for kindness in it." Is this Supplication Halal or Haram?

We are obliged to supplicate Allah, so when supplicating we comply with Allah's Ordainments, and making supplications that are reported in the authentic texts is better. And Allah Knows Best. 

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].