i want to get into TTRPGs but dice rolls and character stats put me off
I'm going to assume you're not being dumb and are looking for gateway games.
There are lots of board games that do the TTRPG thing without the complexity of TTRPGs.
Two I've played recently are Descent and Mansions of Madness. Descent is basically a TTRPG without the RP parts. It's just the tactical combat tied together with a loose plot. Mansions of Madness has the 1920s Cthulhu setting with an app that acts as the game master and tells you the results. I don't like app based board games, but if you like them, it's an option.
There are also a number of tactical skirmish games. Most TTRPGs are tactical skirmish games with a plot around it. I liked the sound of Infinity as it used colour coded cards instead of dice rolls, but I never found anyone willing to play it. Warhammer 40,000 Kill Team is a popular choice, but never played that either. If you live in the UK Kill Team is basically your only option.
On the other side of the coin, there are games that are story focused without being RPG-like mechanically. A friend of mine used to be a big fan of Talisman (we played the digital version a lot on Steam). The Arkham Horror and Eldritch Horror games are full of flavour text that build a story as you play, though I recommend house ruling a few things.
Some thematic games. ie. Board games that kind of tell a story based on how things unfold at the table. Nemisis is basically Alien. Pandemic Legacy is interesting if you can get a group to commit to it, and liking base Pandemic is a must. Unfathomable is a traitor game where you're on a cruise ship being attacked by deep ones (there's a minor amount of wokeshit with an out of place trans character, but is easily ignored). Firefly has characters who are moral and some that aren't, and this effects what jobs you take and choices you make. eg. Moral characters aren't going to be happy stealing medicine.
Finally, some games with RP potential. Robin Hood is a bluffing game where each player is trying to smuggle contraband into Nottingham, while not my cup of tea, lots of people like getting into character as the sheriff. Red Dragon Inn is about RPG characters getting drunk in a tavern trying to see who can be the last one standing. People like getting into character as they play the various cards on each other.
I wouldn't recommend Hero Quest. I know that's a popular option for a gateway RPG, but when I played it I found it boring. I did play the Ravenloft board game once years ago and I don't remember much about it, but I remember it being okay.