I actually stumbled upon this book a few days ago and it has really inspired me. http://www.buddhanet.net/cmdsg/go1-1.htm#Chapter%20One
It's an account of a regular guy who becomes a Theravadin monk, basically on a whim. His experiences and challenges are so mundane (and he is so candid) that I really connect with it. Not a collection of stories, just one detailed one, but hope you like it.
My other recomendation is "Blue Jean Buddha". It's a collection of essays from everyday practitioners. Once again, not solely Vajrayana, but there are a couple stories in there e.g. the Canadian Tulku one springs to mind.
Avalokiteshvara, the Bodhisattva of Compassion, meditating deeply on Perfection of Wisdom, saw clearly that the five aspects of human existence are empty, and so released himself from suffering.