Yes, the infamously known gacha hell. Rate up is truly a lie. FGO offers an excellent PvE content with interesting Chain Turn Based mechanic. Although power creeps servants does exists, progressing the game with low rarity units is a very okay thing to do (But of course you can't resist GACHA temptation). Story wise, TypeMoon did a great job upon the story writing. This game is definitely for you if you like Classic JRPG and PvE based games.
P.S go all out for your husbandos and waifus