There's not many games fully on cart on switch 2, like cyberpunk. But switch 1 has a lot of modules (I'm a collector / curator). Watch for the message on the packaging.
Some are also mixed like batman - first game on module, the others are download. Might still be worth it.
Also most games work fine off cart but might not be fully updated and depending on the updates that might be relevant or not.
It's complicated.