Personally for D and Drop C I use D'Addario EXLS510 (10-46), tension doesn't seem to be a problem, I prefer them slack (I like the Daddario 8.5s for my floyd guitars). Maybe just raise the action a mm to counter the slack-ness, but that's not a problem really.
I always used to use 11s for E and Drop D, and 12s for anything lower, I can't even imagine doing that anymore, I think tighter strings are less likely to make noise if your playing isn't very clean. As I've progressed I've found it easier to play using the lighter strings and just learnt to mute them or stop my flailing fingers from catching them.
I also used to use Ernie's for the first year or so of playing, then tried some D'Addarios for a few years, then thought I'd try some Dean Markleys (hated them) and I'm back with the D'Addarios now, they seem just right for my style atleast.