Hi! Since you didn’t tell me a budget or size, I’m going to talk strictly about upper mid range bras that are for slightly fuller busted women.
I love Elle Macpherson, all of her bras have support in mind but are so freaking sexy you wouldn’t even realize how comfortable its supposed to be:
Gossard also makes a gorgeous supportive bra:
Stella McCartney makes a great everyday bra that can also be jaw droppin’ for sexy time
http://us.asos.com/Stella-McCartney/Stella-McCartney-Penny-Buzzing-Contour-Balconette-Bra/Prod/pgeproduct.aspx?iid=3873542&sgid=8357&cid=6046&Rf-400=3365,14305,3119,13394&sh=0&pge=0&pgesize=36&sort=-1&clr=Pink (I have this bra except with polka dots) it has very light padding and an underwire
http://www.journelle.com/bras/underwire-bras/stella-mccartney-faye-flirting-contour-bra/STE-S23-170.html (I mean REALLY)
Dita Von Teese makes an incredible support bra that is super dominatrix-y and perf:
I hope this helps! I would check out ASOS and Journelle because they both have a pretty big variety. I just talked about some of my favorite designers.
I’ll make a master post soon about my favorite lingerie boutiques and retailers!