Almost all of the bulbs you can find at a hardware store (let alone grocery store) exhibit terrible 120hz flicker. I know because I've literally tried every single one. Also it's not hard to get "high" (~90-94) CRI while nonetheless having terrible deep reds.
Out of the manufacturers you listed, only Philips Ultra Definition (95 CRI, R9 90) have low flicker and good R9. Unfortunately they are poorly made and I have to keep buying new packs each year but it's more cost effective than Yuji for lesser used areas.
Also the claim from TFA is that NIR component improves visual performance (and I've read elsewhere that NIR also has health benefits).
Have you tried LEDVance?
How about Phillips flicker-free "warm glow" bulbs? I honestly have a hard time believing that they flicker because I can literally unscrew the bulb and watch it dim gradually over the course of a second. Which indicates to me that there's a capacitor in front of the LED drivers smoothing the current out. (Which I guess is required to be compatible with triac dimmers anyway.)