I was hoping there would be a perfect fit there but have not taken a bit of time to go through and look at them more closely yet.

I’d skip paying for any boot camps or anything like that, just find a solid lender and agent (ideally who both invest themselves), and learn by doing.

On a similar note, the house will be rented at the time of appraisal, ideally the renter will be keeping it in good shape and clean but has anyone used any specific tips in the past to ensure the house is in the best condition possible for the appraisal?

Not every deal is a deal and your right fit but not work for others so I would stay focused on your objectives. 

Hi all, I'm hoping to move to the US hopefully this year (Tampa) and would ideally like to get into a house hack/my own property straight away as rent is rather expensive.

Ideally I’d like to have about 50 units when I hand off management or build my own business of management.

Ideally I'd like to keep this property in the family, so I'm trying to think of some creative financing strategy that would allow me to buy it from them through seller financing or some other mechanism and allow them to retire with their house equity.Does anyone have any creative strategies to help them that I am not thinking about?

I did a bit of research and trials and found Rentec Direct to fit my needs. 

Ideally buying out the third partner's interest would not trigger a 'sale' and a change in the basis for the remaining two partners. 

To Nathan's point above, the ideal software will do most of what you need not just some.