Is there a sweet spot for number of images/videos in a Carousel Ad?

In short, no.

There isn’t a certain number that Facebook recommends. But, keep in mind if you do utilize carousel ads with multiple images/videos, they will auto optimize and the best ones will rotate to the front.