How to rotate hundreds of objects without key framing each of them?

Yes. Add them to an array. You can then use a Timeline to rotate them by X deg over Y seconds following a desired curve.

The crux is in the details - what’s the order, timing, the overall desired end effect.