I LOVE Spanx Two Timin' tights. They are reversible and really opaque.
DKNY control top opaque tights are really affordable and long lasting. The control top is comfortable and really does not suck you in very much.
http://shop.nordstrom.com/S/2775120 They were on sale during the anniversary sale but it looks like it ended. They usually mark them down every year during their major sales.
If you want to splurge, the entire Wolford opaque line is the Rolls Royce of all tights!