How practical is it to "emotional support animal" your way into a "no pets" apartment?

Let's say you have two cats and you'd rather go homeless than them.

I'm not even sure it would open up my search to include anywhere I'd be able to afford.