This is so true! I'm glad you started this thread because I try to never assume 'fragrant' is going to mean 'smells good'...but sometimes it's hard to know which odorous plants to steer clear of.
I don't have any of my own yucky-fragrance examples, though; most of my plants either aren't fragrant or smell really good.