Two weeks is extreme, but not unheard of. When I was a contractor I would call for an inspection and they would see what slots were available. Sometimes it was the next day, sometimes it was a week out. I understood this to be just part of the business. I ended up in a couple of small departments and even ran a one man shop after becoming an inspector and I utilized the same format, and it worked just fine. Inspection departments are staffed for an average load, and can be overwhelmed. At some point the "average" changes and staffing must be re-evaluated. But it is a slow and difficult process. Departments are either going to end up with too much staff and face tough decisions, or too little, and force delays. What I have seen happen over the past 5 years or so is a love affair with providing next-day guarantees. While this can and often does work just fine, it ignores the fact that it can be overwhelmed and becomes a sell out to to the "next-day" as opposed to providing a quality inspection. I have worked in departments that would send out inspectors with multiple dozens of inspections because they had to honor the "next-day" promise. Is this really a service to anyone?
Two weeks for a normal operating condition sounds like they need to re-evaluate, but getting budgets may prove difficult. On the other hand, blind devotion to providing "next-day" inspections is also extreme and IMHO is an admission that competent inspections is taking a back seat to "customer service". If it is budgetary and controlled by the elected and appointed officials, they should be getting enough complaints to force an evaluation. Somewhere a happy medium should exist.