Add me to the list of haters. I have to use it at my job and I dread it each time I have to use it.
When I look at it, I think - there are so many ways they could make this better.. and yet, here we are with this pile of garbage.
Sharepoint is an awesome platform, but it can be clunky for document management. In fairness though, just about any web-based document management system is clunky. Microsoft has done a decent job at integrating their office applications to work with Sharepoint but even still, there is a definite learning curve. Users want to just save a document and move on; they don't want to have to enter metadata, content types, retention policies, etc.
As a custom application platform, Sharepoint is nice. I can develop apps in days or a few weeks which would take our Java/Ruby programmers months to develop.
Weak search, poor file management, vanishing tables, server maintenance... constant server maintenance.
I don't like second-guessing other IT professionals, but quite honestly, something isn't right with your Sharepoint environment. I've made a lot of mistakes in my own environment as I learned it over the years and it is far from optimal (particularly my SP 2007 farm), but we've not had any of these problems. Of course, I also was an infrastructure person and made certain I put serious hardware behind the farm. Putting big hardware behind a product can mask a lot of issues.
Sharepoint (particularly SP 2010 and above) is an INCREDIBLY complex product. I liken it to an ERP system in terms of complexity.
And they thought I was crazy when I refused to only keep copies of my work on SP. It'll be backed up they said. HAH! I was the only one not two weeks behind in the crash of summer 2012!
IT couldn't retrieve your documents?