If I bought a house at $300k, I owe $250k and house is now worth $750k the County will be slapping me with $10k/year property taxes whereas before I was paying like $3k. My gains are realized each year via property tax assessments :)
This strongly depends on jurisdiction. In many (today I learned, not all) assessed value is explicitly different from market value.
With "unrealized" stock gains you are doing just that - hiding ownership so you don't have to pay taxes while enjoying the perks of the ownership when it suits you
I own in Wyoming. My property's assessed value is like 1/10th the market rate. My neighbour--just checked!--who owns a property like ten times my size, across two plots, and far more lavish than my own has an assessed value similar to mine. The real estate records even have a line item for "actual value" separate from assessed value.
Not familiar with the specifics, but I know California and New York similarly have assessed values that are entirely unmoored from what the property is actually worth.
You are confusing two very different things. You'll realize the gains (and have to pay taxes on) your house value increase only when you sell it. The fact that you were paying property taxes on it all along while owning it has nothing to do with that.