Are there any distance requirements between Arlo Ultra cameras and a SmartHub for recording to a microSD card?

No. If you have an active live stream connection between an Arlo Ultra camera and a SmartHub, then you will be able to record to a microSD card. A microSD card can only be inserted into the SmartHub, not an Arlo Ultra camera.