Okay seriously, how exactly does any wallet generated seed phrase work? It's not stored anywhere, obviously, kind of confused!

I understand when you create a wallet, it generates the seed which corresponds to a certain address on the blockchain. The seed itself is not stored on the cold wallet/online wallet or on the blockchain. It's generated just once upon wallet creation to help guide the wallet at a later stage to show this address, right?

So every address on the blockchain is created along with a set of directions how to get there, the seed are these exact directions, is that right? So what's stored on the blockchain is the address itself, the information about wallet balance and the "information how to get there, aka seed phrase". But the seed phrase itself is not stored on the blockchain. It's stored only on my paper notepad.....

I guess what confuses me the most, since I'm not a dev or IT professional is how does the blockchain address and seed phrase work together? If the seed phrase itself or a copy of it is not stored on the blockchain, how does the seed phrase lead me to the address when I write it in a wallet. How does the seed phrase interact with the blockchain so it can show me a certain address? I dont get it!! If the address itself has no information about that seed phrase.