I respect the fact that some may feel ripped off paying $7 for the Kasumi DLC, but I found it to be worth it for the following reasons.
1) The loyalty mission was short, yes, but the story and location were really interesting enough to keep my attention.
2) The Locust SMG is awesome. In my two playthroughs I've been a Vanguard and Infiltrator, thus only getting an assault rifle in the latter part of the game. Other SMGs prior to the Locust were inaccurate and underpowered. The Locust really improved the offensive prowess of my Shepard(s).
3) Kasumi as a squadmate is fantastic. After all this time, I still get a kick out of Kasumi cloaking, appearing behind the enemy and smacking him/her/it upside the head and then cloaking again. Really a fun and strategically useful skill to have on your side.
I think the key is that the $7 DLC is not just an extra short mission. It's an extra squadmate and weapon that you can use the entire game. So saying that Stolen Memory is only "less than an hour long" is being disingenuous. I'm not referring to anyone in particular on this board - just commenting on other comments I've read over the past few months.
Just my opinion. No need to go spreading it around.
As for Overlord, I'm going to wait on it for now because I've got other games to finish before coming back to ME2 for a third playthrough. It's likely I will get it eventually though.