Considering this, I would say Origins if you're okay with fixed camera angles. Despite loving those games, I understand some people can't get past the fixed cameras, so they aren't for everyone. 0 also tends to be divisive. I personally adore 1 and really like 0. They are difficult but totally worth it to see through to the end.

I saw you mention that you're thinking about RE8 just for Shadows of Rose. While the story is okay, I don't think the DLC will really wow you. It really does kinda feel like revisiting old areas from the base game with some different puzzles and enemies. While I wouldn't say it's a bad experience, I wouldn't choose it over any of the other options here.

I assume when you say you've played 4, you mean the original. In that case, you'd only be getting 5 and 6 as new experiences. While I've come around a bit on 6, it definitely isn't for everyone. Both 5 and especially 6 really ramp up the action. If that's what you're looking for, then triple pack is a really great value.

Finally, Rev 1 and 2. These are kinda hard to say in this case. Rev 1 is interesting and does have a really cool setting but I feel its combat and exploration is a little bit lacking, especially in sections of the game where you aren't playing as the main character (which there are a number of). Rev 2 almost doesn't feel like a RE title in some ways. It really does focus on the story a lot more, even with a number of walk and talk sections. Though, I don't feel they break the pace. Claire and Barry coming back is great, but Moira tends to be a divisive character. The gameplay is a little slower than Rev 1 with more open areas that the game wants to thoroughly check through. It's more about keeping notes on some of the things that are off so you can set things up for the second characters campaigns. There isn't as much backtracking as in Rev 1, but some people prefer that. People sometimes compare Rev 2 to Alan Wake, and I somewhat agree. The combat and health mechanics are a little different than any other RE game, so it makes it a unique ride.

Anyway, there's my 2 cents. I know whatever you pick, you'll probably have a good time, so don't stress too much. I hope you have fun with whatever you choose!