I had a piano teacher named
Melody. :) Cheesy indeed. Plus I had a elementary school music teacher who named her daughter
Melody. Also cheesy. :) I don't really have an opinion on the name either way. I agree that it fits in well with
Tiffany and
Stephanie.
Elodie is nice. I like the English pronunciation and can't see why it wouldn't be fine to use that - assuming you are not in a French-speaking country that it.
Elle is a great nickname.
I definitely prefer
Elodie.