No, faith doesn't necessarily get you what you want from God.
Hebrews 11:6
And without faith it is impossible to please God, because anyone who comes to him must believe that he exists and that he rewards those who earnestly seek him.
Also, you're distorting Mark 9:23. It referred to those who believed Jesus when he was talking to them.