My thoughts to your thoughts.
I always was kind of dissapointed I couldn't use C# in the SSIS Script Task but my dream came true in SQL Server 2008.
Read this excellent post from Denis Gobo!