Maybe for a programmer SSIS is a big improvement over DTS, but for a normal user who just wants to dump the data from a table, it's overly complicated.
I am a Programmer, and have worked with VS for many years. My impression is no different than yours. 'Overly complicated' is a polite way of describing it. I'll keep using DTS for as long as it's supported.
Tom Garth