For personal use I personally like the office suite. Bloat, but everything works without tinkering.

My use case with CMS is business related. I'm looking for a solution that can

handle millions of documents and folders,

versioning files,

handle metadata to the saved files(types),

be able to search between documents fast,

has a standard protocol or at least a nice API(nice==documented),

able to handle java transactions (xa) and

has a UI for manual testing

Self hosted option