Are you still looking for articles in this vein? I've been overhauling a lot of my organization's unit test infrastructure and thinking about what makes for good and useful tests as I work through them. I've one example where I took a mostly useless unit test and overhauled it to provide greater value, and thanks to source control, I can probably replicate the steps easily enough.

I've also been stretching the limits of what I can do with unit tests and the SSIS Catalog...