Joseph Manola has written an article on magical effects in OSR-type games – which ones are fun, and which ones sap fun and challenge. Come for the insight, stay for the list of magic items that embody the good effects. It feels important.
Perhaps unsurprisingly, his lists fit awkwardly with the (e.g.) BX spell list, especially above 2nd level.