
Apple
AirPod Pro Series
Apple-integrated, great ANC, but fit issues & poor Windows support.

Running these analyses costs money. Buy through my links to help keep lights on! I may get a small commission.
qcy melobuds n70, last i saw 50 dollars. it is somewhat serviceable. i would highly recommend - anker soundcore liberty 5, i c most often around 90 dollars. it is a very good choice for around 100 price range. even at full price, it is good. you are not using the anc feature, the battery will definitely last you for a good long time. low sales , promotion times, i saw it around 66 to 75 dollars or sth. if you dont use anc, in the buds you get 12 hrs of usage. it has all the modern features properly implemented. app is also very good. skullcandy method 360 anc, is also somewhat good choice, if u wanna go back to the same company. but it is a new diff app though. it is on the upper side of 100 dollars. all above 3 earbuds are recent releases. nothing ear open , is a very good open ear earbuds with excellent sound, within your budget range. it is one of the best open ear earbuds
For serviceable anc, you gotta spend some bucks, there is no way around it. Cheaper lowest price good anc product would be anker liberty 5, sometimes promo offer s or sth , I c it in lowest 66 dollars then, even at somewhat full price anker soundcore liberty 5 are worth it. These are light, and these also have a good battery life even with anc on. Then another mid budget type, but with top of the line anc, would be bose qc 2024. It has bose premium anc. It has more battery life than bose expensive premium qc buds. This is bose attempt at budget earbuds. Good fit and comfort is super important for anc. also hv sth playing(maybe like jazz relaxing music) while anc on, you will get the full anc effect with these buds Bose qc 2024 I wear it without fin tips 4 to 5 hrs, I walking, grocery shopping, sitting @ a desk, it is very good fit and comfortable for me.
i think you are talking abt sony xm5 buds, they are known to be uncomfortable. anker liberty 5, it is a recent release, very light bud, with good sound. if you dont use anc, you will get a much longer battery life. bose qc 2024, i use it without the fin tips, as they hurt my ear. this has good long battery life even with anc on. above two are medium range price, recent release buds, very good value and all over quality for the money. if you dont need anc at all, nothing ear open, is the best open ear earbud. it is also light and comfortable. fit and comfort are not same for everyone. my friend uses small size eartip in left ear and medium size eartip in right ear. me saying that to note to you that it is not necessary for both ear eartip size to be same.
you hv to hv sth playing like lo-fi jazz music or sth, while anc on, to get the full effect of anc. maybe try over ear headphones. after using earbuds i am never going back to headphone again for multitude of reasons. earbuds like - anker liberty 5, skullcandy method 360 anc - these i c cheaper price sometimes. for good anc you to pay some money. better seal, fit and comfort , then also sth playing while anc on, is a factor.
Liberty 5 nc for me
I've used these soundcore buds for over a year. I accidentally washed and dried one of the buds and it still works fine. https://www.soundcore.com/products/a3957-liberty-5-tws-earbuds?ref=true-wireless-earbuds&_gl=1
I recently received the Soundcore Liberty 5. They are around 160 AUD and have transparency mode and active noise cancellation.
Don't know about other buds you mention. But definitely avoid 4nc. It's pretty decent sounding, but forget comfort. After 1-2 hours, your ear will sore badly. The chassis is bulky and protruding inside your ears. I'm using liberty 5 currently and am pretty satisfied with it. Still comfortable to use after a few hours. But it's quite more expensive.
Definitely not, I got them and returned them specifically because of the sound quality.

Apple
AirPod Pro Series
Apple-integrated, great ANC, but fit issues & poor Windows support.

OnePlus
Buds 4
Budget ANC king, but no wireless charging & windy transparency fails.

Beats (Apple)
Fit Pro
Workout secure, Apple-friendly, but wing-tips tear and case feels cheap.

Anker Soundcore
Sport X20
Value workout buds, secure fit, but connectivity can be iffy.

EarFun
Air Pro 4
Budget champ with great sound/ANC, but transparency has static.

Ranked #1
Apple - AirPod Pro Series

Ranked #1
Technics - EAH-AZ100

Ranked #1
Beats (Apple) - Fit Pro

Ranked #1
ISOtunes - PRO Aware 2.0

Ranked #1
Apple - AirPod Pro Series

Ranked #1
Shokz - OpenFit Series