That is a wonderful history, NeoMetallix! I'm in a somewhat similar realm, where Resident Evils 1 and 2 were my introduction to the franchise back in the late 90's. I can't recall which came first for my playing, but I loved (and feared, as I was younger) both games. I've beaten Resident Evil's 1 and 2 on the PS, never 3 though. I've watched someone beat it when I was younger but never could pull it off myself, as Nemesis made it difficult for me! Code Veronica was also wonderful, but sadly have yet to beat that one as well! Resident Evil 4 was most definitely a masterpiece! It wasn't my favorite of the bunch simply because I adore the old style and Resident Evil 2 brought it to me in the best way I could imagine, but I totally get why most regard 4 as the top spot! For a horror action game it really can't be topped!
I also didn't much care for 5, and skipped 6, though I may return to it as to get the story beats out of it. While it was definitely a let down game, the story does carry forward from there to 7 and 8, so I best keep myself informed since I love the franchise! I imagine 7 in VR would be just an ADVENTURE, and I wish I could manage that myself. Someday, I will give it a go! Same with 4! (They are getting that to go VR soon I've heard whispers of).
I'm glad you enjoyed Resident Evil 4, Infinite! I will caution you that the older games are a different style completely, emphasizing more on the horror and strategy, with item management, puzzle solving and ammo conservation being key elements, but I can say that Resident Evil 4 would never have been what it was without that backbone behind it, so I think you'll stand a good chance at enjoying those games! As far as beyond 4, it'll probably be spotty, though even the games many don't enjoy, some find exciting. Maybe you would be a big fan of RE6 and that would be awesome! I'm almost certain though that you'll enjoy 7 and 8 if you get to play them at some point!!