I realize not all police officers are "gun people". In my experiences, police officers that are "into" guns seem to be in the minority. Is there a need for more or better firearms training? Should officers at the academies be exposed to the various types of firearms and their safe operation?
This should happen, maybe it will in the future. Some cops figure their 46+ rounds are plenty. They have no concept of "battlefield pick-up." Even for officers with rifles, some think, everything will be over before they ever run out of ammo. They see no need to familiarize themselves with common weapons that criminals use: Various handguns, SKS rifles, AK rifles, AR rifles.
In addition, I would like more focus on teaching officers they need to constantly read various legal statues, and try to their best to memorize them. Unfortunately, some officers don't do this, and in some cases, officers have no idea what the law specifically says. There are also some issues with officers determining if they have reasonable suspicion to stop, and in some cases, probable cause to arrest.
The fact remains, not enough good, logical people want to do the job. That is all there is too it. The job also draws a lot of folks who actually want to be in positions of power over others, and they see a badge as a way to achieve that.