Has anyone had a good experience from printing and distributing flyers for your design and print business?

If so where was the best place for distribution? What would be the ideal things to have on the flyer to get attention?

I am thinking of doing some flyers for my business but have heard a lot of stories of people getting absolutely no business or the wrong kind of business.

Thanks,
Lance