That doesn't make sense in regard to oils like euro C3 and A3/B4 0w30 and 40. Those have a minimum HTHS of 3.5 and have higher kv@100C than pretty much all non euro 5w30, 10w30 and 10w40 oils. 15w40 and 20w50 might have higher values but won't be as robust in additive package and wont have as high of quality base oil blends.
That being said op has a mechanical issue that oil isn't going to fix. The afm/dod lifter design is poor, kind of like those kia/Hyundai engines you're constantly trying to quiet down. At least theres a fix for the GM engines

(afm/dod delete cam/lifters/tune).