For anyone else who has a UFO-crazy uncle, I've found Mick West's YouTube channel to be invaluable https://www.youtube.com/c/mickwest. Mick is a retired video game programmer (Spider Man, Guitar Hero, Tony Hawk), who does extremely well-researched videos analyzing UFO claims.
He's not flashy or trying to be entertaining, just thorough, evidence-based and scientifically rigorous. He'll even do controlled experiments, recreations and 3D models to validate what's going on. And he's unfailingly respectful no matter how unhinged the claim. His work explaining the "Gimbal Video" is a good example: https://www.youtube.com/watch?v=Q7jcBGLIpus
Three of my favourite game series as a kid, what a legend.
Sounds like you've already decided and are trying to work backwards - as in the supposition "UFO-crazy" seems more like you're trying to wrangle some analysis to prove your inter-family ad-hominem than following the evidence to illuminate a mystery, and Mr West's work is abused for that lol
He doesn't seem to explain the recently popular "transients" though.