Hey Ryan, not sure where you live. But in Oakland and San Francisco, which have some of the most draconian rent control laws, no-fault basically means the tenant didn't violate one of about 8 reasons that a landlord is allowed to terminate. The main one is failure to pay rent. But also there are others such as damaging the unit, causing a nuisance, etc. But if you are terminating because you want to move in, or you just don't like them anymore, or you want to fix up the place, those are all no-fault. In that case, yes, you will need to pay the tenant.
I'm actually hoping this law goes into effect because as of today CAR negotiated it down to just one month maximum payment. Which means, now I'm assuming state law still supersedes city law, that instead of having to pay 10-20x months rent to get someone out for no-fault eviction, it's now only 1 month.
Yes, it really does cost $8000 minimum in Oakland to get someone out, and in SF it very quickly goes to many 10s of thousands. Having to pay a tenant $200k plus is not unheard of there.