If a tension rod doesn’t work for you I would say f-it and just drill holes for the curtain bracket assuming the screw anchors aren’t absurdly large. Assuming your walls are neutral colored, I think it’s easier and less noticeable to patch a hole than it is to match paint on the chance the adhesive you use pulls the paint off during its removal.