theological foolishness

In another thread, the topic of hymns with theological depth came up, which raised an interesting sidelight that I think may be worth exploring. So here goes: What is theological depth in a hymn or song? What hymns do you consider to have such depth or grounding? Are there any songs/hymns...