In Star Trek Picard we see Raffi living at rock bottom for a while. She has no job after her discharge from Starfleet, and is clearly not doing as well. She describes her life as humiliation and rage.

And yet by modern standards she has a home, food, and power. Her drug usage isn't condoned but she's left largely alone to do it. By modern 21st century standards its a very soft landing.

Does it get worse than this? What is the worst possible economic outcome someone living on 24th Century Earth is likely to face.

The events of DS9: Past Tense imply that things aren't as bad as sanctuary districts and mass homelessness, but there's a lot of range between that and where Raffi landed. So what evidence do we have about how bad it can get?