Foreign keys both define relationships between tables, and also enforce referential integrity. The discussion is about how we could potentially mine various additional value from foreign keys as an information resource, rather than just mostly being about referential integrity.

Why do you think it's opaque? They declare relations between tables. That's structure, intent. Making intent clearer is generally a good thing.