Bear in mind that the vast majority of municipalities receive money from tickets through their municipal courts and it is earmarked, a small percent at a time, to fund specific community projects. The money goes into the general fund of the city, not the police departments bank account, much less into the hands of anyone in a uniform. I think people often think the officers can somehow get their hands on the money at will. In the vast majority of places, this is simply not true. It should not be true anywhere.
As for confiscated money, there are strict federal guidelines that determine what can and cannot be seized and what can be used and what can't. Situations like you mentioned, CC, would not cause suspicion, but when a 17 year old has $6,000.00 in his pocket and no visible means of support (no job), and when asked where the money came from, his answer is that he cuts grass, in January, really? Add to that he is holding small quantities of drugs, packaged to sell and has prior trafficking charges and I don't think he should be allowed to keep that money. Once the federal criteria is satisfied, that money is used to buy equipment to assist in arresting more drug dealers. Many times, what is bought is lapel camera's for the officers to wear both in uniform and undercover.
Unfortunately, there are some small communities that rely on revenue from tickets to cover operating costs, but most people know that, and are careful not to fudge on the traffic laws, even a little. Tickets are not written for "supposed" offenses. There are plenty of laws, ordinances, and violations to write tickets for, without having to make up reasons. As a matter of fact, officers often write one or two of the more serious (dangerous) citations and just give verbal warnings in lieu of tickets for other less serious or lesser known violations.
The problem is, no one ever deserves a ticket, if you don't believe me, ask them.
Writing a traffic ticket is one of the least enjoyable parts of being a cop, but it is necessary. Think of all the people who ignore traffic laws. How many more would that be if there were no consequences for it, other than wrecks? Everyone thinks that won't happen to them.