Bandit09,
I hear you regarding spending money on pay per click and getting very little in return. Did the same thing myself when I first started out and it's very frustrating and discouraging.
Have you thought about any other approaches to affiliate marketing besides pay per click? One method that I really like is Travis Sago's Bum marketing. It's affiliate marketing through the writing of short articles and using blogs or Squidoo. It does take a little more time and effort to set up than an Adwords campaign but (and here's the part I love) it's totally free to do and can get you earning some money without spending any.
If you're interested in this type of method check it out at
Bum Marketing Method(the course is free too so you don't even have to pay to learn it).