I did now test in CMIS Workbench, there I see an option "Max hits", when I put 1.000, I get 167 records. If I use it by Drupal CMIS module, I only get a limited subset. I will have to show further for your other questions. But it would be interesting to know how CMIS Worbench sends the "Max hits" to CMIS.
select d.*, t.* from cmis:document as d join cm:titled as t on d.cmisbjectId = t.cmisbjectId
where d.cmis:name LIKE 'CT-%' ORDER BY d.cmis:name ASC