I'd say it's still very worth playing. It has a lot of tropes that future games took inspiration from, and it's art style is iconic (in part because the character designer and art direct was Akira Toriyama, of Dragonball fame). If nothing else the soundtrack will grab you by the ears and draw you in.

I've seen people bounce off of it, no shame if that happens - in typical JRPG fashion of the time it came out it's involved (there's some non-intuitive progression steps) and takes about 20-30 hours to complete.

There's a DS version which I can't speak to since I've only played the original SNES version, but I understand it adds some additional content that's not required for the story.

I play it on average once a year, the full 6h playthrough.

Yes. It is one of the most polished JRPGs, and there are no random encounters or grinding. The game can be played through in 24 hours, with optional side quests.