do your own analysis - yes, get your Excel spreadsheet out and put in all the variables and prove to yourself if it will be worth your while - don't take your financial advisor's or friend's advice on face value - they have their own motives, and at the end of the day, whether it is worth investing in property will depend mainly on achievable capital growth rates in relation to loan interest rates.
the LEAST you should do is ensure you pay full cap amount of voluntary concessional super contributions each year through salary packaging and invest money in term deposits if you do not want the risk of shares.
a SMSF will make your accountant richer and give you more headaches with its complexities, BUT it can give you more control, avoid impacts on your cash flow from an investment, and if you choose wisely and buy well, you might be able to make yourself the same as you would if you had been able to invest at 7.5% return in a share portfolio but with the “security” of bricks and mortar although you and your family will not be able to live in it unless it is sold out of the SMSF.
the maximum property price which could be serviced through a SMSF without using after-tax income is ~$850,000 on a 25 year loan which would mean you would have to sell it when you retire to avoid the negative cash flows in retirement.
the maximum property price which could be serviced through a SMSF without using after-tax income is ~$730,000 on a 15 year loan and thus would NOT need to be sold on retirement if it continued to provide at least a 4% rental yield.
if you negatively gear property, there will be an impact of your cash flow, headaches associated with managing the property and tenants, and if you buy well, you might be able to beat the return of a share portfolio that returns 7.5% pa, but this option does have the significant advantage of forcing you to save more money and thus you could get even better returns.
you have to decide if your life is so boring that you need to make it more complicated and stressful by investing in real estate to get a few extra dollars for your retirement.