Like anything the key is relevance. If you can put together a good affiliate site with plenty of good content and market it "consistently" you should do fairly well from it.
If however you enter a saturated niche, with poor content and don't market it, it will be a total waste of time