>and if someone can turn a hotel into apartments successfully, which sounds like a challenge to me

It can be done, but I've more often seen apartments built over ground scraped clean than retrofitting an existing building. Honestly, hotels are probably the closest kind of building design that one could get that might be worth converting into apartments.

There are two buildings near downtown in my city. One was converted into studios, the other now bills itself as "student housing".