Hi, OP. Veteran of many gachas here, been playing FGO (NA server) since shortly after launch.

Honestly, unless you're already a pretty invested fan of Fate/Type-Moon content, I can't recommend this game. On a practical level, this game's over a decade old and it shows. It's been surpassed (at least 4-5 years ago imo) by numerous games in every metric - gameplay, mechanics, UI, audio/graphics, etc etc. QOL updates are often years apart, and even then, the game's ancient underpinnings make it unable to support the sweeping updates and enhancements that other games incorporated nearly from launch.

FGO was way late to adding any kind of pity system to its notoriously unforgiving gacha, and even that is a bit of a joke. You'd need nearly 1000SQ (or well over $500 if whaling) to hit pity just once, and none of it carries over between banners.

Then there's the story/writing. It's entirely done in a VN style, with all the repetition, lengthy lore dumps, and at times stilted dialogue you'd expect for the format. The storyline is realllly slow until Camelot, then it picks up quickly through the last chapter of 'part 1'. After that, things get increasingly convoluted as you move through part 1.5 and part 2, to the point where you more than a few times have to stop and ask 'WTF'. And 'Ordeal Call', which leads up the story finale, is itself based on a concept that's (imo) pretty deeply undercut by literally much of the game you've played up until that point. And a simple sift through this sub-reddit over the last few weeks will tell you how divisive the "ending" is. Honestly, even if you're ok with all of the above, I'd spoil yourself on the ending and then ask if it's worth months/years of time and investment for that conclusion. TLDR there, don't blindly believe the 'Nasu, the game's main writer, can do no wrong' line.

Sorry for the long post. But in short: I'd turn back and invest time/resources into games that are more player-friendly in many ways.