I work for my state government and I’d say at least 50% of what I’ve worked on over the past 20ish years hasn’t ever made it to production or at least was used

I work for my state government and I’d say at least 50% of what I’ve worked on over the past 20ish years hasn’t ever made it to production or at least was used sparsely in production. Main reasons for this include: leadership cancelled the project and decided to spend 5-10 years on a RFP and implementation from another company. Leadership had some vanity pet projects they wanted to make them look good and once they left it died on the vine. My manager had some “great idea” and assigned me what amounts to busywork. A common thread on many of these projects is that I ended up having to play a BA role and gather requirements or in some cases make up my own requirements.