You should go for it, but be prepared for a very long hard road.
Also be prepared for the fact that whatever you have in your logbook will never be enough for what you want to do. Whether it be a lack of turbine time, mountain time, off airport landings etc, it's never enough.
I know of enough people (me included) that have worked hard and now do what they love to do. It just takes determination. Try not to put yourself in to financial hardship as was mentioned earlier. My old flight instructor took 8 years to gain his ratings as he flew once a month because he couldn't afford any more. He now flies 412's and 222's for an EMS company and is one of their instructor pilots.
As for stories which one? Probably my favourite from my training days was when I missed my intended airport by a mere 30 miles. My first solo cross country. Thank God for GPS now! I didn't realise that I was in the wrong place until I saw the airport name written on the hangar roof. That brought me down to earth a bit as I was sure that I was doing a great job.