I loved Resident Evil but it was the third one that really got me, with the havoc in the streets and the scare where you realize Nemesis can literally chase you from room-to-room and/or show up literally anywhere at any time.
When you get to the area with the bazillion spitting statues that respawn when you do, it became very clear that Fromsoft was out of ideas for making the game both interesting AND challenging.
My bard and Astarion work as a team to do the robbing. When you perform, crowds gather around you, so it’s very useful for redirecting prying eyes so Astarion can pick pockets.
Bards are objectively the best if you want the full breadth of options to move the story around. If you want to kick ass in combat or sling more spells, other classes are better at those aspects of the game, but Bards are going to give you a lot more to play with in terms of the RP.
Not spoiling anything either, but you can always try bard and change your class later, as there is a mechanic in the game for that.