Is Pinecone worth it for prompt pack design? Pros/cons?

Context: I'm working on model optimization 062 and ran into a decision point.

• What I’ve tried: basic setup + quick benchmarks.
• Constraints: limited time, want something stable.

Question: Is Pinecone worth it for prompt pack design? Pros/cons?

Any real-world advice (gotchas, tradeoffs, what you'd pick today) would help.