Typical scenarios for collection types include:

User Collections that any registered user can create to organize items they deposit.
Exhibits that staff create and curate for public display, where items can be included in any number of exhibits.
Controlled Collections created and managed by staff and not intended for public display, such as collections associated with organizational units or departments.
Community Collections that are intended for public display, similar to how DSpace communities and collections are sometimes used.