RF 24-105 F4-7.1 IS STM For shooting paintings?

[BeccaBoni]

I am rediscovering my love of photography and I just purchased an EOS R6 Mark ii that came with the RF 24-105 F4-7.1 IS STM lens. I was previously using the Rebel T7 with the lens that came with the 18-55mm lens. I have recently been learning how to photograph paintings as I have mainly been shooting outdoor macro and landscape. I'm finding this to be more challenging than I expected and I really want the most appropriate lens that will capture all of the texture and detail with my new camera. I was mostly shooting outside in the shade,  when it's cloudy, or at sunrise before the sun comes out with my Rebel T7. What lens recommendations would be suggested to shoot in raw using manual focus for shooting artwork? 

[ebiggs1]

"The hardest part will be lining up the camera to get a flat plane to shoot out, ..."

 Absolutely paramount if you want the best results.

[kvbarkley]

If you can rig up a thin rod that is perpendicular from the painting, you can adjust the camera until the rod "disappears" and all you see is the end.