The loot is there consistently, but it's really hard to get all of it especially as a TH9.
Once you get halfway through Crystal I, it's pretty much all TH10's with lvl 2/3 IT's set to multi. There's occasional premie bases, but they're more rare the higher you go.
So, you basically get into the mindset of trying to get that 1 star and looking for bases with storages out on the edges that you can get. Most players are better up there, so they'll have their storages spread out as well.
From what I hear as you get higher into Masters and Champions you start hitting the max bases that truly don't need their gold, and those are much less protected so it may be more consistent.
No matter if it's good or bad, I strongly encourage you to go up there and have some fun with your balloons to see for yourself. I always enjoy pushing with mine.
If you're planning to do that for your farming, then I'd suggest tracking your gph over several days and make sure you take into account your losses on defense. Then it will be a little easier for you to decide which farming approach is better for you and your playing style.