I only have experience with SQL Server Express (my employer was still using their licensed copy of SQL Server 2000 when I got there in 2009). There are a lot of features I'd love to have that are missing from the free version such as replication and automation tools.