Sure, if that’s what you want.
I’m not sure at this point which cameras expose their motion sensors to smartthings, though, it has changed back-and-forth a few times. Arlo and Ring are the two with official smartthings a Integration‘s (although not all models for each), so you can do some research to find out if their motion sensors are triggers for smartthings Automations.
Ring exposes theirs to IFTTT, I just don’t know if they do to smartthings.
Arlo has more granularity, but only if you are paying for their subscription. And again, I don’t know exactly what it does with smartthings.
Both brands also expose their Motion reports to Amazon Alexa routines, which is an easy way to get chimes. 
You could start a new thread called “motion sensor alerts from cameras?“ And then hopefully people could give you more specifics.