I have several systems of RPi4s running newest bookworm taking photos with these Arducam64s
True Arducam does not seem to be too interested in providing a tried and tested workflow to make their cameras actually work on the RPis, but us folks in the forums have figured out our own hacks over the year.
I currently use this walkthrough i posted mixed with @henri 's suggestions