Provided that Cash Drop Sniper continually makes shots whenever possible, it will be able to generate cash steadily. If affected by Buddy Bloon, it is only worth making a shot anyway if cash generation is more important than its damage.
At 1 more Gold and making 3 Gold per 2 turns instead of 2 Gold per 1 turn, Cash Drop Sniper's cash generation is slower and less efficient than a Banana Farm, but has the advantage of an initial burst of damage.
Cash Drop Sniper is often outclassed by monkeys that have either more reliable damage or better cash generation; a competent opponent will outrush a single Cash Drop Sniper placed early, and the cash generation is too slow and inconsistent to be kept for the mid-to-lategame.