Affiliate Marketing Secrets

I have a few blogs which get maybe 100 visitors a month. This isn’t generating much revenue from AdSense. Of course, it’s likely not getting high CPCs on the ads. I don’t want that to be my aim. I’m looking to find what monthly would be good enough traffic to make decent money off of even with low CPCs.
What kind of traffic would give me spending cash, like to see Broadway musicals or something? And what kind of traffic would be required to live comfortably off of it? I don’t need Beyonce numbers. Just something reasonable for a good niche site.