I can and have worn a variety of styles and rises, but probably prefer (slightly low) mid rise for comfort. Underwear is of course available in a variety of rises also. For a lower rise, I prefer a longer hemmed top; for a higher rise, a shorter one. In my neck of the woods, most currently available, fashionable, premium denim tends to be mid rise and not super tight.*
But, I have kept some pairs that are lower rise and slimmer (waxed cotton habitual brand and earnest sewn) bc I’m fond of them. Whether one can and should wear low rise depends on torso length (comfort) and a full length selfie (for some people with longer torsos, a low rise is not as attractive).
ETA: with either rise, I’m not fond of stretch denim bc it sags. I only buy denim that I can purchase in person, not on line. Bottom line, wear what suits your body type, budget, lifestyle, aesthetics. And, be sure it fits
(*ETA: Fashion of course follows the young. And, younger people — I’m 57, so this encompasses quite a few decades — have been wearing tighter tops and looser pants, mainly mid rise,even if they appear to be falling off the hips, for some time lol

A French tuck shirt (half in, half out works for a variety of rises and volumes)