Now that's a long read! Can't wait to get through it, maybe on my next flight.
Regarding the lore, I've always imagined RA2/YR + RA3 as non-canon or simply an alternate reality. Westwood was going to link them together with Tiberian Incursion (Yuri's allegiance was with Nod) but when EA took over that was all canned. Thus, this is my timeline: Red Alert > Tiberian Dawn > Tiberian Sun (all expansions included). The end of Firestorm and the supposed defeat of CABAL is where the story ends, with GDI recovering and rebuilding and Nod, under Slavik, doing what it does best - surviving.
Tiberium Wars and Kane's Wrath aren't included because I hated what they done with Nod, didn't like the direction of the story, and most FMVs were terrible. Don't even get me started about Tiberium Twilight.
Edit: Forgot about RA2 and RA3 lol. Gameplay for the former, good, the latter, bad. The story and FMVs were too silly, I wish they were more "serious" like RA1. A positive note: Kari Wuhrer as Tanya was HOT and my favorite actress as Tanya.