there are a bunch out there really. audio technica ath-m50, akg 518, sony XB series...I recommend you go to a local store and try some out. Best Buy usually has listening stations and most shops that sell musical equipment will let you audition sets. The prices tend to be higher than online, but you can get a listen usually. Also keep in mind that most places have 30 day return policies so don't be afraid to just try a pair out for a while, as long as you have reviewed the policy well and are OK with it. Also be sure to take a look at the headphone review section here. read through some and you can get a good idea of several sets.
oh, and waht you are OK with wearing in public is completely up to you. thats a very subjective criteria.