I agree. And I think this says a lot of the sorry state of Open Source (actually, even proprietary) CMS engines.
Wordpress is kinda nice, but it too breaks down.
For sites after a certain level of complexity, instead of CMS like Drupal etc, what would be useful would be a CMS lib, to build your own solution around.
Don't have my work in your idiotic constraints, just give me something like (fake language):
front_page_articles = get("type"=>"article", "limit"=>5, "published"=>true, "order"=>"DESC");
search_results = search("query"=>$query, "limit"=>100, "order"=>"RELEVANCE", "range"=>[10,20]);
add_document("body"=>$body, "title"=>$title, "createdBy"=>getCurrentUser().id. ...);
The thing that Apache Jackrabbit could be, but isn't exactly/yet.