I watched the pilot episode (Gathering) and it was pretty awful all round - bad acting, dialogue, plot, and yes, horribly dated SFX (I think the CGI must have looked terrible even back in 1993)
however, I assume it must get better, since it has loyal fans and a good rep with critics - and it could hardly get worse. After all, early TNG episodes were dire too.
And that Strazinyski guy sounds like a bit of an ass from what I've read. Still, I'll give it a shot.