It all depends on how much each one changes.
For subsonic it’s 1/2 * density*Velocity^2 * Cd * Area.
So for example, if you halve the Cd but double the area, you’d get no net gain.
For supersonic it’s alot more involved.
I was once told a simple answer for the question: “How do planes fly?”.
Answer: “The plane pushed down on the air, and the air pushes up on the plane” i.e Newton’s second law.
Picture that and I think you should get a basic understanding of how it should work without falling down the rabbit hole of complicated math that’s required to get precise numbers to make the plane perform as desired.
This mutual pushing comes in the form of pressure differences over an airfoil. Faster flowing air will have a lower pressure (not counting shockwaves).
If you picture the air moving across a symmetrical airfoil, particles will divide and go both above and below the airfoil. Since it’s symmetrical, the distance from leading to trailing edge is same on both the upper and lower surface. Therefore, the velocity of the particles should be roughly the same, and so, collectively, will the pressure they generate. This means that to generate lift with a symmetrical airfoil, you have to increase it’s angle of attack to the freestream. Symmetrical airfoils tend to be used for high speed aircraft due to reduced drag. In other words, the angle of attack affecting lift is because of the airfoil selection.
For a cambered airfoil, the distances are different. In order for the particles to meet at the trailing edge at the same time, one particle has to travel faster. So if the particle traveling along the upper surface travels a longer distance, its speed will increase and the collective pressure across the surface will decrease. Higher pressure on the bottom pushes harder than lower pressure on top and the net result is lift upwards.
Under certain conditions, the particles don’t meet up at the trailing edge at the same time. This likely results in flow separation (i.e. the air is no longer hugging the surface of your airfoil). Bad things happen if this occurs over your control surface because there is no longer any air for it to push against! You basically just created a vacuum.
These are all generally 2 dimensional considerations to simplify and break up the problem at hand.
TL;DR: The drag may or may not be more, it depends on the actual numbers. Blah blah, Lots of basic aerodynamics explanations that have been done to death already, blah blah. Lift at hypersonic speeds having more to do with angle of attack is actually because of the airfoils used.