I too always have doubts about how 'sexy' I look in various outfits/lingerie etc, but have always had really positve reactions from those have dressed up for, I think a lot of the time they are overwhelmed by the effort taken and how gorgeous you look, the little things, like wobbly bits etc, that we stress over don't even figure on their radar. i tend to wear everything with a killer smile and even more killer heels and it does wonders...
I have this http://www.lovehoney.co.uk/product.cfm?p=20224 which was really well received, the length of it meant it skimmed my bum, but the sheer back meant he absolutely loved it, as you can see from my review the only problem I had was the length with the sussies. This is for the plus sized one but they do the same style in regular size too. I have a few 7toM products and they've all been great.
I also disagree with Princess bout bodystockings, prior to having worn one I would have agreed, but having now worn loads I love them, my bloke loves them sooooo much and god knows how but they make me feel sooo sexy, and believe me, I have a fair few lumps and bumps, haha!
The beauty of Lh is the great returns policy, so if you do order something and don't like it, you can return it and try something else, go for it, am sure your partner will absolutely love it 