Personally, I believe that most people could get a good program from any old muscle mag without paying somebody and just experimenting. There are a few demographics requiring special needs that I truly believe trainers can help.
Sadly, thanks to YMCAs and LA Fitness Clubs all over, the 'real' trainers out there get a bad rep.
Anybody with fifty bucks and an internet connection can get 'certified' nowadays