The Embedder's Dilemma: LLMs Are Better, but at What Cost?