I have seen it used when eulogising people that died of natural or medical causes. (And I agree that it's distasteful)