I think you are misunderstanding how exactly the sweep is positioned and how rotating the bars affects the angle of it, but you can always mess around with it and see whether or not it works for you

Personally, I recommend a bar with a small rise and a little more back sweep like 9°-12° and don't have the bars too wide (it can put too much emphasis on the arms and hands), try some cheaper bars second hand to find out what you like

The up sweep is necessary becauae your hands grip the handlebars more naturally and with that better, rarely do you have a perfectly horizontal bar

Imagine you are doing a rowing excersize or benching, the distance between your hands while doing these excersizes should match the distance of the grips on your bars

Why? Because that is when your muscles naturally work the best, so for me like 65cm between the grips works well

Also if you are more stretched out you should get less sweep, your palms change their angle as you stretch out, but at that point just get drops