Or do you want to be able to find documents within three seconds of someone asking for them?
Is the right workflow one where you can forecast your work for the coming month so that everyone knows what’s planned?
It’s probably a mix of all those things, but only you are going to know what will feel like nirvana for your team. Here’s where to start repairing your process:
Focus on one of your problems to fix, either by giving one of your processes another try (perhaps with a few tweaks) or trying something new. Once that area of chaos is under control, move on and try to bring some order to another area. Trying to change too much at once is a recipe for a different kind of disaster and it will unsettle the team to the point that it undermines what you are hoping to achieve.
Finally, you’ll have to accept that what is billed as “the perfect process” might not work for you. If you can’t make a best practice work, then change it. Tailor your software and processes so that they help you, and don’t hinder you. That’s a process of continuous improvement and if you work closely with your team to identify what is working and what needs to change then you can deliver incremental improvements and slowly bring that chaos under control.