Great thread, intro! You certainly match your name.
I don't have much more to add, though it has occurred to me that prayer is more often for the emotional and spiritual benefit of the one praying than for anything that was actually asked for.
What I mean is, that when you pray, it concentrates your thoughts on to the thing/s you are asking for. By doing this, your mind is less distracted by other matters, and mentally you are able to focus on what you truly need.
Othertimes, other thoughts may come in, which may be your sub-concious mind saying to you "you need to give this some attention". They may be things you thought were unrelated, yet they come up. It could be the Almighty putting those thoughts in your mind. Who's to know?
When you finish praying, your mind is refreshed, and able to recognise the real issues. Hopefully then an answer comes along, whether or not it was what you asked for.
Crossroads, I like that Garth Brooks song as well - sometimes we certainly can "Thank God for Unanswered Prayers".