Battlestar Galactica-FTL-jumps have imho the best effect, even though it is pretty simple. Unfortunately they show it only in the pilot I think.

And the CGI are actually pretty bad. But that series is so good.

Niels Kobschätzki @nielsk