No, you are only describing a part of what borrowing is about. Your use case is valid, but it is just one of many use cases. Consider the following:
I own a a long-term retirement account, but I need to pay an emergency medical bill and don't have cash at hand. Obviously I don't want to liquidate my savings account, but I can put it up as collateral to go to a bank and get a cash loan. If I'm unable to pay the account may be liquidated. That's an overcolleralized loan. It's useful. The same is happening when you put up your house as collateral, or arguably even your reputation.
The blockchain equivalent of this is the same. You put up one asset as collateral e.g. Bitcoin, and you can get another more liquid asset.
Another use case for this is simply market exposure and hedging. You can put up Bitcoin as collateral, still having exposure, and then use the loan to buy another asset to get exposure to, creating a more complex structured exposure. This has nothing to do with blockchain, it's the same in traditional finance.
Every loan has some form of collateral. Even credit cards do, it's just less tangible: you are staking your credit score, which they'll start chipping away at as soon as you start defaulting.
Credit cards are loans based on future income streams (which can be securitised in fact with crypto technology -- think a defi bank automatically getting 20% of your future income until it is repaid)
Smart contracts are Turing complete and you can build anything with it. You can even build an opt-in judiciary system with the power to reverse transactions.
I think you'll be pleasantly surprised if you look at how DeFi actually works.