Hi
I would prefer to go with SQL Server 2008 instead of 2005. 2008 has somany featurers.
But it would be great if you could list out what are the difficulties you are having in Site Server and then see how that is resolved in 2005.
List out what made you trigger this process of moving out of Site server or upgrading site server.