Oh, it's worth a watch. The intro sequence (no spoilers, but when you get to the dog scene, you'll know what I mean) is just great, and there's a handful of classic lines I quote to this day. (Sarah Jessica Parker and the Coke question! No VFX needed, it's solid gold on its own merit.)
I honestly don't know how the film holds up today, especially from the eyes of a grown-up watching it for the first time. The overall narrative may or may not earn its keep, I guess. But all those VFX shots were in service of a larger story, and if nothing else I think you'll appreciate them more in context.
I recall Paul Rubens, jokes about Twisted Sister, morphing spaceships, time travel, Fort Lauderdale Florida (which seemed impossibly alien to this midwesterner), and a lot of pop culture references.
I honestly don't know how the film holds up today, especially from the eyes of a grown-up watching it for the first time. The overall narrative may or may not earn its keep, I guess. But all those VFX shots were in service of a larger story, and if nothing else I think you'll appreciate them more in context.