One obvious application: your family doctor will have an MRI machine in her office, same for all physio clinics
If this proves true I'd see their use more in electronic circuits. Novel sensors etc rather than classic high power high field uses people dream about when the words "room temperature superconductivity" gets thrown about.
The failure modes would mostly be the same as for the big ones: sucking in metal chairs if you're not careful.