I'll go with everyone else and say it depends on how well it's done. The Enterprise finale took place either 5 years or 100+ years in the future (depending on whether or not it was the ENT timeline or TNG timeline). Either way, bad finale.
I think that's a perfect example of it depending on how its done. TNG did it and it was one of the best series finales ever. Enterprise did it and it wasn't very good at all.