If you're going to live in or use the property for a long time, possibly. I've also been looking at buying property with these mortgage rates, but it's not intended as a short term investment.
In terms of investment property or flipping, there are many factors and you might want to look at what happened historically.
For example, raising interest rates significantly like Volcker did in the 80s stopped new home building cold because new buyers could not afford mortgages. They stopped building the subdivision my family lived in for 3-4 years when this happened. In general, people who bought just before that period did not see a return on their home for a decade-plus, but the economy rebounded quickly after that period
https://www.cnbc.com/2019/12/09/when-volcker-ruled-fed-peopl...