Depends on your setup.
If you have a massive HD flat screen TV and want it to look all modern and swish, I believe Hyperspin is still going.
If you are running a 15Khz CRT, then something like attractmode is what I'd go for.
Personally I can't stand Hyperspin, it's too flashy and modern looking. But that's just me.