...A tip for RPGs, especially fantasy adventure RPGs. Special powers above and beyond the magic and fighting people can do in the setting are not required for a main character. At best, these attempts tend to be laughable, at worst they take themselves super-seriously like Pillars, despite having no meaningful consequences at all. Don't try to fill in a backstory, maybe sketch out a host of options, but as soon as you lean on a player and start dictating things, you're departing from the fundamental starting point of an RPG: the creation of a character in the player's head.
You also need to survey people about more RPGs and fewer shooters. You managed 2 of 6 this time around.
I agree with the tip (one of the reasons M&B was so good), but by your count they had 3 of 6:
BG2-RPG
vampire-shooter
ME2-RPG (baseline modern shooterRPG)
dishonored-not an RPG
fallout NV-shooter/exploration
PE-RPG
i had a very similar discussion with a friend about 20 years ago, i forget the game we were talking about, but i felt it wasn't an RPG and he did. he argued that an RPG was first and foremost a game that immersed you in a role. which widened the field considerably, the end result was that i became convinced that a game could be considered an RPG if it filled in the little details of the role in which you are to play in the game. this means that Alpha Centauri is a RPG due to the story elements integrated into the game. that being said i wouldn't categorize it as a RPG, as it fits neatly into the 4x genre.
i consider half life to be a better RPG than vampire, though i'd still call it a shooter, and vampire isn't really a shooter exactly (i'd call it a 1st person adventure game). system shock is a better example of a shooter with a stat system and a storyline, it fell neatly into the shooter camp and did that job quite well, the stat system help enhance the FPS aspect of the game, and the storyline was sprinkled in FPS style so it fit neatly into the game. vampire was built on a FPS engine, so it felt clunky as an RPG, and early on it was trying to shove the RPG down your throat a little too hard, which made for a strong gradient between action and story.
i prefered BG1 over BG2 due to how they threw the story at you. early on you are given a story that directs you on a time sensitive rescue mission (big bad is going to escape from prison and hurt your sister who is with him), it is at this point that you are charged with completing almost all the side quests available in the game to fund a jailbreak for your sister, instead of dealing with the authority directly (like a lawful person would), or walking from the whole thing (like an evil character). in the end you are the chosen of bhaal, instead of a spawn of bhaal who has managed to stay in the running by surviving. it is still one of the best games made though.
ME2 had a pretty big break in style from ME1, the combat was more arena style in how cover was used and set up in the places combat would happen. i'd walk into an area and see the layout and know that if i cross a certain threshold that i would have a major battle on my hands, given my first playthrough was carrying on a sniper from the first game i had to hope that the enemy didn't drop in on top of me (which happened far too often). my second playthrough i focused on powers and it was nice, third playthrough assault rifles, and other than ammo issues at times was nice. the ability to kneel and get a boost to accuracy in the first game and a lack of triggered mega battles (the enemies tended to by on map from a long distance away instead via event check points) so you could approach carefully and set up your position to keep you from getting overrun. in the second and third you just rushed in guns blazing and hoped you can shift on the fly if needed. the boost to presentation with character writing and cutscenes and such helped make the second just as good as the first, but in a different way, instead of a lesser game. the third took the changes i didn't like between 1 and 2 and ramped those changes up (not counting the ending and the large chunk of main story left out in the day 1 DLC), though it did have some nice epilogue scenes for your party members.
never played dishonored (i think i might have gotten it on a steam sale, or humble bundle, but i don't have any interest in it), so i can't comment.
fallout NV is marred by having to fill fallout's (1&2, and to a lesser degree tactics) shoes, which thanks do to fallout 3 i doubt it can do. i've tried a couple of times but it doesn't feel right, from the combat system to the economy. the combat multiplies things, so early on you are poor at stuff, and later on you are good. sure that is how it is supposed to be, but in the first 3 (including tactics) games your weapon was important, and your skill made you able to use it well. same goes for armor. in fallout 3 and NV a poor weapon in a high level character's hands is better than a good weapon in a low level character in every regard, even how the weapon operates. this makes leveling very important, finding good stuff is important too, at least at low levels when you don't find good stuff unless you meta. the economy is out of whack compared to the older games, you get too many caps, and things cost too much (best generic assault rifle in 2 was 1k, in NV it is 5.2k). you use ammo at low levels to much for how easy it is to get, and at higher levels it is too plentiful.
i haven't finished my playthrough of PE, i put it down to wait for the expansions. since then quite a bit of balancing has been done which was probably its biggest flaw when i played it. i like it, and will get back to it eventually. i have some more HOI4 and M&B:WB to do though before i jump back into it.
walking dead (telltale) isn't on the list and is quite different from most RPGs. more like a choose your own adventure. the biggest flaws with the series is the railroading that gets done to minimize meaningful paths and reduce content. i tend not to replay these, as the choices i make dictate my character, and replaying that would strip away the illusion of choice, heck sometimes the game doesn't seem to reflect choices i have made.
chroma squad is a tactical JRPG that is fun to play as it has plenty of humor mixed in. i haven't replayed this game as there isn't really any branching paths despite being able to do things differently, in that regard it is quite JRPGish. JRPGs tend to very railroadish and have a focus on a narrative they are telling you, with combat being more about min maxing what little you can adjust.
M&B is a sandbox RPG which requires you to tell your own story and use your imagination more for the story part as it focuses on the action and world shaping of your actions. mods really make a huge impact on this game, and lends itself to them quite nicely.