There exist a variety of union lists and shared catalogue for archival and manuscript (AM) material in the world. There is some overlap in coverage and holdings, but to find everything, one must search each of these. Some deal with specific jurisdictions (indicated by the flags on each item), and some deal with wider geographic areas.
It can sometimes be difficult to identify an author's "main" collection - there may be manuscripts and other material in more than one archive, and that author may be represented in a vareity of other collections or archives (their correspondence, for example, with other authors, may be in that other author's collection).
Most of these tools use Library of Congress Subject Headings (LCCH), which is what academic library book catalogues use to describe their holdings, but there are also a variety of archival description standards that are in use across the English speaking world:
Maintained by the International Council of Archives :
Maintained by Archive Canada:
Being familiar with these descriptive standards can help you find entry points to the collections you're seeking - what fields to search against, how to search them effectively, how to craft keywords, etc.
For best results, search on many synonyms and name variants (natural and inverted, "Cormac McCarthy" and "McCarthy, Cormac")
Some biography sources will point you to an author's archival and manuscript collections: