A ban on drones in parks in Coventry will cause more problems for police than it will solve, a former West Midlands chief inspector says.