I know sorting has been mentioned elsewhere for specific instances, e.g., for search results or subsorting, but I thought it worthwhile to create a general sorting topic, with examples. I've divided the topic into two categories: general sorting and manual sorting.
General sorting by field/attribute
Sorting is essential for a DAM/catalog, whether within search results or while browsing a catalog folder or contact sheet. For reference/ideas, attached is the Sort menu for Media Pro. I believe the default order is based on time added to the catalog (oldest first). Also attached is a partial shot of Media Pro's List View options. These are used for sorting by clicking a column in List View (also shown below) and include many more fields and attributes than the regular Sort menu (media info, EXIF data, etc.). Media Pro permits 10 columns max. I understand List View is not on the current road map for PM+, but I attach both screenshots here to show how Media Pro handles sorting.
Manual sorting
And, in case no one has mentioned this, it's important to also allow manual sorting, i.e., by dragging/rearranging thumbnails, in any view (including query results). In addition, where technically possible, the app should give users the option (e.g., in Preferences) to remember manual sort orders each time the app is opened (e.g., at least for folders and Collections, but not queries). Edited for accuracy/clarity.