Most advisors see the reverse mortgage as an ill-advised last resort, but others say it can be useful for seniors.