My three 2nd level spells thus far are pyrotechnics, color spray, and distressing tone. At level 5, I added distressing tone, so I haven't had the opportunity to try it out, but I think sickened will stack well with shaken. Once, my DM thought if something was intimidated 3 times, it would run off, and that made for a very interesting game (I basically scared some dudes into running through all the traps for us :]]) Also, at level 5, I have base 21 intimidate, 23 when I tap myself with my wand of Tap Inner Beauty.
I've been carrying a torch for pyro, but close range really defeats the purpose of pyrotechnics imo. There are so many good 2nd level spells I am sort of overwhelmed. I'm not taking invis cause I'll just buy all the potions of it I need, and I don't want to take Heroism, because I'll soon have a wand of it, if I find it necessary.
So if I had to boil it down to a specific question, it would be the following- What second level spells should I take, considering the huge chunks of APG and UM we (the bards) got a piece of?