Personally I’d say no.

You have to consider the highs and lows when deciding to embark on >20 hrs commitment to consume any particular media. I think the absolute high of the series is Carnival Phantasm, which is a joke slice of life OVA. It is legitimately fantastic.

But to enjoy Carnival Phantasm you have to understand Fate stories and Tsukihime. IMO, Fate never recovered from its origin of being a schlocky early 2000s visual novel with obligatory sex scenes. They awkwardly tied a critical in-story magic mechanic to sex, and the sex scenes are hilariously baaad and really out of place, until the 3rd timeline/storyline of Heaven Feel, where the themes are more mature, and even there it is still edgy. You generally have 3 options, 1. Just tank through the awkward and hilarious sex scenes. 2. Read the PG13 version, where they cuddle instead. But the cuddle version makes so much less sense in term or character relationship and growth compared to explicit sex version. 3. Just fast forward through the sex scene once you hear the sleazy porn music. You still suffer through the cons of (2) that you missed out on some genuine character development. And (4) skip the VN entirely, for anime adaptation, which is an adaptation of the PG13 VN, but there you still suffer the same caveats as some development in character relationship made less sense.

I’m not a prude or anything, but they never got around Fate’s origin of being sleazy early 2000s VN. There’s structural weakness around the storytelling, around the sex mechanic that they never patch up properly, and instead they build upwards onto spinoff games and multi-billion gacha game.