Thank you for sharing your experience with the Community @Johnboy! At this time, our Chime devices can only assign one tone per alert type (motion / ring), and cannot assign a different tone per linked device. With you having two Chime devices there, we recommend dedicating one to the Cam and the other to the Doorbell in order to achieve different alerts.
This is something that has been requested in the past, and I will definitely share your feedback with the team to reinforce the value in this feature! I hope this helps 