Ask HN: Do You Use Foreign Keys?

The answer should be obvious, but isn't.

I'm curious to hear real-world experiences that go beyond database design 101 textbooks. Have you faced any tradeoffs, surprises, or regrets around this decision?