Fwiw, this is what I did that worked out great for my 2023. The Black Roof Console Connector X2 has the Ground (Blk/Wh) at Pin 5 and Switched Power (Purple) at Pin 8, as mentioned earlier in this thread. This is the connector closest to the driver when you drop the overhead console (the other connector you don't use is gray).
I got the connector with the pigtails that fit the mirror PN# 13540313. The link is a page or two earlier in this thread too. After confirming the wiring and tested, I simply unwrapped the cloth tape a few inches, and ran a razor blade around the Blk/Wh wire in two places approx 1/4" apart, and tightly wrapped the Black wire from the pigtail then soldered. Same for the Purple wire and wrapped the Red from the pigtail, and soldered too. Wrapped both leads tightly with electrical tape, and secured with some small nylon zip ties. I don't believe there is a Reverse wire available up there on the Refresh, so I didn't use the green lead from the pigtail.
Entire project took about 30 minutes. The hardest part is getting those two T15 console screws back home. Thanks to all of the earlier contributors for making this an easy mod!