IMHO, the best source material for supers campaigns, generally speaking, is the team titles, not the solo stuff.
So ignore Superman, Daredevil, Spawn, etc., look at X-Men, Justice Machine, Legion of Superheroes, and so forth. Why? Besides the obvious, the team books tend to skimp on the narrative complications The Human Target mentions above. You might get hints here and there, especially if something major is developing for a character, but for most team books, you won't see much in the way of a character's missing out on a mission as because her kid has the mumps or he has jury duty.
...though excuses like that may be handy if players actually have to miss game night...
Instead, unless and until the personal life sans masks starts to impact cape time, the team books tend to have a more..."action-centric" pace.
They also tend to introduce complications that most solo heroes don't have to deal with, like maintaining an obvious base of operations, or if they don't have one, the logistics of how the team can assemble when needed. And those complications can be good sources of plots.