@Dav Pohote
This has already been stated, but I'll state it again and elaborate. Since this is a commercial REI post, the question seems a bit contradictory to the general commercial investment strategy. But, as has been stated, it depends on your goals.
Here are a few things to consider: how long are you planning to hold the asset? Over 15 years? Over 30 years? The longer you hold, the more Capex risk you have, above and beyond routine maintenance. Do you expect to live long past that time frame and be healthy enough to fully enjoy that great cash flow and deal with the landlord stresses? Are you investing to make money and live life on your terms? Or are you working to invest and want to continue investing by working for the capital? The later seems to fit many people when they do not consider the costs of capital... That is, they just keep working and trading their hours to save up more capital, versus the mindset of having the actual investment quickly repaying the capital.
These questions will lead you down the correct investment path for YOU. Because it's different for everyone. Because we all have different goals and operate with different mindsets towards investing. Some are data driven and profit driven, others are emotionally driven and have grand visions of great appreciation through long-term holds. Some are still trying to figure out what drives them. There is no one perfect solution, just as there are so many opinions.
My opinion, for commercial REI, is to first go with the easiest loan you can qualify for. Do not get picky if you are starting out, or else you will never start. Next, pick the terms that will mitigate your risks the most, which can mean terms with true cash flow 10 years down the road, or terms with cash flow now to recoup your capital. The first will require you to have another form of cash flow to sustain your lifestyle and future investing, commonly being a W2/1099 job. The latter will be pushed by your lack of a job or pursuit for quicker financial freedom.
I normally go with 5, 7, or 10 yr term, depending on rates. I have a few sub 4% at 10 yr, a few sub 6% at 5 yr, and even a 7.5% at 5 yr. Just got priced yesterday for 6.2%. it all depends on my EXIT strategy.
I always recommend an exit strategy. I would not want to be 60, 70, or 80 dealing with tenants, if I can help it.
For me, I go with those metrics and it often leads to short/medium term financing, amortized for 30, and often I/O. I do not have plans to pay off any of my current assets, I want cash flow and appreciation, and I want to stay financially free with the ability to continue to invest without a job.
As Joe has pointed out often, your tenants are paying the mortgage, not you. At least you should not be, if you pulled the trigger properly. If this is a business, it needs to be profitable, just it need to be self sustainable and generate cash flow. That's how a business is valued. Or else, you are collect properties and incurring risks without reward. I know it may trigger some if I say that appreciation is speculation, but it is still somewhat true. I don't bank on application, but I do try my best to control it and capitalize on it when appropriate. I am not in the business of collecting properties, but if I were infinitely rich, may be I would, but I'm not. REI is my business, and it is always a continual pursuit to make it more efficient. It must cash flow for it to be sustainable and revalued higher for equity extraction (appreciation play). If I were of the mindset that I buy with higher debt terms for the sake of quicker pay off and realize higher cash flow later, it would not be a business and I would likely still be working a job.
Many of the posters here are already financially free, but either chose to continue to invest, continue to work, or a combination of both, but not a necessity. I bet the folks that are financially free via REI will often have a different outlook on this subject from those that are depending on a job and are just collecting real estate.