Well, tides on moons (eg around gassy supergiants :)) are fairly usual.

So perhaps it’s not as much as the tides being “sci-fi” (sci??) but the relative size of Earth’s Moon (it’s basically a binary planet situation where they orbit around each other).

So, the sheer size of our moon as seen from the planet’s surface is the rarity.
(Then again, on a moon around a supergiant the same experience could be had from one tiny beings pov.)