How is it different from window.localStorage.setItem('user-id', 'user123');

I look at it like so:

Local Storage: Key Value

IndexedDB: Structured Document Database

OPFS: BYO File Format

But all operate under the same restrictions and set of considerations.