They really have the most beautiful graphics and typography I've ever seen.
Here is their 3D logo with their slogan
Or, to make it easier, here is a PDF that Proud Creative made about their font: http://proudcreative.com/download/proud_case_studies_fl_syfy.pdf

P.S are there any cool similar fonts? Preferably free...

Syfy Sans  Suggested by Huxy 

The Slogan font is Crank 8. or if you want to, Draw your own text handmade by another font. In Syfy's case, It's a modified Crank 8, but REALLY modified, if you want to, compare the "Syfy" text written in Crank 8 with the photo you uploaded. I suggest you the Syfy Sans. but if you want it, get A LOT OF MONEY and buy it's rights actually owned by Syfy. but in then you can't share it to ANYONE IN THE WORLD. The only similitude on the logo/Crank 8 comparing is (probably) the Y. i suggest you to buy it's rights if you want it.