I got burned out on the genre pretty quick early on. Once Nemesis hit, it felt like they were all out of ideas.. felt like a unused asset, B tier, Majora's Mask shit. I wish I remembered more of RE4 back then (I remember bork back then praising the shit out of it more than the gameplay itelf
), but I remember jumping on RE5 on launch and thinking it was just ok. I completely skipped 6 because it simply looked dumb as shit with the "over the top anime style action cut scenes" ..like they were trying to emulate John Woo flicks, but totally missing the mark... They lost their way again. However, RE7 really was the true RE renaissance imo.. And in VR, it felt like experiencing RE1 again all over for the first time (in true 3D). And then followed up with REmake2? Capcom was muthufuckin back.
That being said, I wish I could share your enthusiasm for the franchise as a whole, but I feel it had more than it's fair share of dips.. However, mad kudos to Capcom for keeping it alive with top tier effort. Granted, I never cared for zombie stuff or horror movies even back in the 80's and 90's, so it never resonated as much as it did others. I just wanted to shoot exploding stuff with various weapons.

Every franchise has dips. That's what happens when you're a franchise. But RE more than any franchise I can think of knows when it's time change things up with those dips. And those low points are very, very short. With RE Code Veronica was a low point but they immediately came out with the best remake ever in REmake. RE6 was a low, but it came out in 2012 and RE7, which is highly regarded (can't wait to play it), came out in 2017 just a few years after. Meanwhile Final Fantasy has been an MMO for a decade with one mediocre single player entry and a controversial remake. GTA hasn't had a new game in a decade. Virtue Fighter is dead. Uncharted had only one entry last gen and it was at the beginning of the PS4 generation. Gears is past its glory days and so is Halo. Where the fuck is Mass Effect? Where the fuck is Dragon Age? other old franchises like Diablo barely innovate or do new things. Diablo is Diablo. Civ is Civ. What you see is what you get. Meanwhile Resident Evil is an almost thirty year franchise that manages to continuously revamp itself, stay current, and innovate. You can't really pick many franchises that can claim this, dude. You're missing my argument as RE had no low points. It's what it does after those low points. Most series never or barely bounce back. FF released XIII and kept giving us crap. RE released 6 and 7 came out a few years later. They were like,"what's RE6?" I cannot think of many franchises like that. Hell, we are in a thread for a remake of an almost twenty year old game that is seen as one of the most hype releases on the year while other franchises are stagnant or forgotten. That means something.
In terms of franchises that have similar longevity the only ones I can think of are Nintendo franchises like Mario and Zelda. Or Dragon Quest. Or Street Fighter maybe? Zelda came out with II but then Link to the Past came out. When they mastered the Zelda formula they came out with OoT, a certified banger classic. Even if you aren't keen on Majora's Mask, it's an experimental, unique game which takes balls to release after a game like OoT. Then Zelda had a stagnant period and bounced back with Breath or the Wild and Link Between Worlds and Zelda is probably more popular than ever in 2023. That's what I'm talking about: longevity. I'd say RE has had a shorter stagnant period than Zelda milked the OoT and LTTP formula for ages. Only Mario has been as consistent and always evolving. 64, Sunshine, Galaxy, and Odyssey all play different from each other with completely different focuses. Hell, there's even a vast difference between SMB, SMB3, SMW, and YI.
Donkey Kong could be another contender. Went from the original Donkey Kong to DKC to 3D Donkey Kong to Jungle Best to Donkey Kong Returns. Now there's rumors of an open world DK. Few gaming franchises have longevity like this. Even then DK doesn't have the popularity of RE.