For me, it’s all in how you approach it. I’m reading the Dragonships of Vindrash series by Margaret Weis and Tracy Hickman, and they have a prophecy of sorts. I don’t mind it at all. They don’t harp on it. We understand the main character is supposed to do something great and they focus on his journey, rather than the prophecy, or his destiny to help save the gods. If writers decide to include a prophecy or a destiny, don’t beat the reader over the head with it. Use it as you would foreshadowing. Give the reader a taste and let them salivate for a while until giving them the whole meal. Just one guy’s opinion anyway.