Do you need to request an activity to have someone personally share or is there a searchable database with keywords to find activities?

It could be both. There is the export/import function to share cases. There is also a search function with keywords to find activities/exercises. However this will also depend on the keywords used when developing cases.