Among others things, I have worked at NASA and currently consult for Missile Defense and DoD industrial base.I’d like to invest in the local community since I know it’s a pretty awesome place to live, work and play.

But if I wanted to try renting it out on my own is there a consultant type service where I could a knowledge expert walk through my house with me letting me know what upgrades are likely necessary and what would not lead to actual value. 

I am an investment consultant and have provided RE consulting services to a number of clients. 

@Jimmy ThomasYou should consult with a CPA and attorney on tax and legal implications.

Contact a local architect/engineer for a detailed consultation specific to your project/locale.   

But if I wanted to try renting it out on my own is there a consultant type service where I could a knowledge expert walk through my house with me letting me know what upgrades are likely necessary and what would not lead to actual ROI.

To specifically answer your question on taxes (of course consult your CPA) CA is ruthless if you live in CA and have any interest in any LLC’s no matter which state they are in.  

With all of your calling, lists, door knocking and communication campaigns, I would keep in the back of your head, the necessity to be very very clear, succinct, and upfront with every aspect of your endeavors with a  borrower, especially if they are in, or on the brink of being in foreclosure, so that you do not run afoul of the foreclosure consultant requirements in California, and many other states.

Read up or consult an attorney about the legal differences.

You use the same type of lender, reno consultant, and contractor.