huh.. that doesn't sound like lifter tap to me.. that sounds more like spark to me. it's really fast.
if you open the hood at night without any light, you might be able to see it.
it's been a while, remind me again, the miss comes and goes when you drive it, or it misses all the time? and what have you done? new plugs, (hopefully not Delco from Amazon) plug wires and coil pack on that cyl or swap pack to another location to see it the miss follows?
I was going to say yeah from like 2008 when gm added the afm lifters and stuff they just don't go 300k like they used to. before then they did but the afm lifters need fresh oil and the factory says you can do 10k on the oil, which you can't if you want it to last over the 130-150k that they all fail at. gm needed to set the oil change light at 4-5k on this afm stuff. but it was long out of warranty, so they didn't care. the new LT ones are even worse. their afm stuff is failing under warranty so gm is freaking out. my buddy just rented a 2023 suburban for a holiday trip, and he said it never went into 4cyl mode. they seem to have turned it off at that factory after having such a high failure rate and parts shortage to fix it.
sucks you're stuck upside down with a broken truck. I've seen it a few times on this board. one guy bought a used one for the family, engine valve train failed a 1000 miles after he got it. ended up having to pull more loans and wait a month for a reman engine to be put in. at that point dude is 25k plus into something worth 10k on a good day. another kid has one, sounds like he can bearly make the payment, owes away more than they will give him on a trade in and it's a ticking time bomb waiting to leave him stuck. the non hybrid ones on top of the afm lifters. eating themselves, the torque converter in the 6 speed trannys eats itself about 120k and takes the tranny with it. there's a good 5-8k$ rebuild too. it's all brutal if you're not a mechanic, these trucks will turn you into one. something like a afm delete kit. can be done yourself for $1k and upgrade the cam for more power, but a shop won't even try that for you, they just wanna swap in a new engine. same with that tranny, catch it before it goes out and you can put a upgraded bullit converter in and be good for long time. cheap ish to do yourself. nightmare to pay a shop, most don't even want to install aftermarket parts, so they put another stock one in.
but with all that said, maybe someone else can listen and notice something I don't. but it doesn't sound like valve train to me.. since this isn't hybrid specific, just engine related. you might post this sound clip under the engine/drivetrain section that has way more traffic. no one really looks in hybrid section cause it's mostly questions about why my hybrid battery is dead type of thing.
*edit. as for cutting your losses and buying a Toyota. honestly, as much as I enjoy this hybrid yukon and since I work on my own stuff, I will keep it because I find it interesting. but if I was in your position, I'd probably dump it for a loss and find. something else.
just my 2 cents.