Phillips, GE, Cree, and others sell high-CRI bulbs.

10 years ago you had to work to find high CRI bulbs but could still find Cree bulbs pretty easily. Now you can get high CRI bulbs at the grocery store.

High CRI bulbs generally have low or no flicker because high CRI is toward the premium end of the market.

IR emission is not a "feature", it's a bug.

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).