Well, I disagree, that rpg games in general are addictive. I play lots of different games, and I do not have the feeling that they are in any way more or less addictive than other genres. The exception is of course mmorpgs.
I would not even say, that rpg games are inherently fun or good. One can put a lot of things into such a game, that will be appealing to some people. But some will be deterring. To pick three examples: grinding, turn-based combat, crafting.
With no grind at all, it's maybe not a rpg, but a visual novel in disguise. But hardcore jrpg grind is not for everyone either.
While there are action rpgs, turn based is the default. You need time to do the deciding. But there are different types of turn based. Much can be done by quality of life features there, but there are also aspects of familiarity, nostalgia and limits of the engine. Personally I find the combat system of rpg maker to be horrible. But I do like turn based combat in general.
Minecraft is the most sold, most popular game. Modification or creation of equipment is a logical extension of looting equipment and fits into the genre. But this does not say, that every game should have crafting mechanics, or that all people will like them. Some might cherish them, some might see them as a distraction.
So, what's this then? How do we make the perfect rpg, that some would call addictive? Is it the middle ground for all the aspects you could think of? Just put every mechanic in, that a rpg could feature? Probably not. There are successful games that feature only very few mechanics. Some so few, that they are not even recogniseable as rpg. Like auto battlers. And even some idle games. Some forgo story and focus only on crafting or combat. Or exchange turn based for action combat. Some cater to a nieche topics or focus on story.
Maybe it helps, if we see a rpg game as a meal to cook. Adding all ingredients and spices will not taste good. And there are lots and lots of combinations that will taste good, but not to everyone. So, if your rpg needs crafting or a minigame, is the equvivalent of the question of adding salt or a side dish. Adding salt to ice cream is generally not a good idea, but there is still the flavor salted caramel. Adding too much salt is possible too. And adding a side dish of potatoes to a pizza might seem odd. And while I am talking about pizza: pineapples!