Basically, what you are talking about is a form of leveraged investment, investing borrowed money in the hope that your returns on it will be greater than the interest you need to pay on it. This becomes a question of how low the interest rate is on the loan compared to the expected range of rates of return on the investment, how much you trust your ability to predict the latter, and how much you can afford to be wrong.
Specific example: I had sufficient investments to cash out and buy my house outright, though that would have left me with lower cash reserves than I liked. I chose instead to go ahead and partly finance it. I believed I could probably average "market rate of return" (historically around 8%, not 10%) over the duration of the loan, and that would beat the fixed-rate 6.5% I was borrowing at, so I was reasonably likely to come out ahead versus not borrowing, and could live with the result if my guess was wrong. But to play it a bit safer, I financed only 50% of the purchase price, not the 80% which is more typical in the US.
As it turned out, I was able to refinance the loan down to 3.25% a few years later, making the return on this decision even better and further reducing the risk of an undesired outcome.
So, yes, I definitely won. That was emphatically not a guaranteed outcome.
Normally I consider leveraged investing without a huge amount of research and monitoring a great way to lose your pants, never mind your shirt. But this specific scenario -- leveraging a loan I was going to take anyway -- was the lowest-risk leverage I was ever likely to see, so I went for it.
Increased returns almost always involve increased risk (though the reverse isn't true). You need to look at the specific case, run the numbers, decide whether the worst case is acceptable (and/or if you have an exit ramp should one be needed), and decide whether the risk/return balance is one you find worthwhile.
There is no one-size-fits-all answer; situations vary, available alternatives vary, individual comfort with and reaction to risk varies.
By industry standards, I'm told, I'm considered a fairly aggressive investor, largely because I'm willing to work on a longet time horizon and not stress too much about short-term swings, even large ones. If that describes you, there might be an opportunity here. Or might not. Work through the numbers and the possibilities and decide what you can live with.