I also like to RP my chars too (I mean, I play Roleplay tabletop games) but I did not find any game based in D&D or PF which is not combat-heavy. Even in the games you said, Fallout new vegas or Dragon age origins there are a lot of fighting involved. There is a lot of very good dialogs, indeed. Plenty of choices (DA games went to the gutter when they started the dialog wheel thing)
In POE2, for instance there are many choices for unique dialogs based in race or background, and plenty of skillchecks so it has tons of replayability. Even in DoS2 there are lots of dialog variations for different characters, sex, race, etc.
But still in those games you are fighting 80% of the time. Period.
The only games based in a tabletop that allows you to RP more are the memoria games, based in TDE, and they are mostly a graphic adventure game. And the incredible Planescape torment and Age of Decadence. I wil also add Tides of numenera, but man... the game has so many flaws. If you use skills you only have to fight 3 or four times in the entire game, tho. Like in VTMB.
And I do not know if you can call that full RP, if you compare it with a D&D tabletop session, even online.
I've never heard of Age of Decadence, what is it about and what system does it use?
https://www.gog.com/game/the_age_of_decadenceIt´s a CRPG indie game of a small company. There are only two games in this setting I know of, this and Dungeon Rats. It is a small game (length like TOEE) but it has lots of backgrounds and factions, and the world changes a lot depending on your choices and skillset. I replayed it a lot.
As a charismatic loremaster or as an assassin you do not even have to fight more than two or three times in the entire game if you have the right skills( you have 23 skills, from impersonation and disguise to persuasion, sneak or alchemy, but it is not Skyrim, your character can only handle a few of them).
There are also factions, like the merchants or the thieves guild, whose missions do not require to have any combat skill to gain their favor.
There is also the Legion, mercenaries and the Gladiators arena that are very combat-oriented. Fights are unfair in this game, tho. I do not mean only difficult, they are unfair. I did not really play much those kill-everything-on-sight paths, to be honest. But as I said, there is no need for fighting much for some backgrounds, factions or builds, unless you really want to.
(I do not mean to compare this game with PS in storytelling, characters, etc, because like most games, does not hold a candle, I only make a comparison in the fact that you spent a lot of game time outside combat too)
ED: There is a guy that claims that you can make a pacifist run, not fighting nor killing anyone and get one of the endings of the game, and I think it´s true, but you miss a bunch of quests and game content in the process.