Siri Remotes purchased from Apple before October 18, 2022 would connect to an Apple Lightning-to-USB cable.
Siri Remotes purchased from Apple after October 18, 2022 would connect to an USB-C cable.
Identify your Apple TV remote - Apple Support
Charge your Siri Remote - Apple Support
You may charge to a computer USB port, or you may charge to a matching power adapter in an AC socket.
Any brand of USB-C cable is fine for the Siri Remote (3rd generation). Any USB-C power adapter is fine.
USB-C to USB-A cable in combination with USB-A power adapter (like for iPhone) is also fine. Any wattage is fine for this remote (it won’t use more than 5W).
Apple branded examples are:
20W USB-C Power Adapter - Apple Store
USB-C Charge Cable (1 m) - Apple Store
Cables and Power Adapters - Accessories - Apple Store