I live in a very expensive market (Seattle, WA) and I am looking to invest out of State.

You live in Ohio where for whatever reason people want to invest from out of state.  

Should I be budgeting significantly more sense people are in and out of the property versus them living in a long time? 

Get a duplex and live in one side.

It will be remote, but since you live there now, you probably already have connections who either already know the house or local friends to find you good people to service things as needed.  

If a home was previusly owned and lived in by a famous person, does it add much value? 

It makes sense for house mates, spouses etc. to be Additional Insured on a renter's Insurance policy if they also live there and keep their stuff there (although I think anyone on the lease is typically covered anyway).

.- The townhouse you're moving into is currently a rental, but you plan to live there two years for the 121 exclusion.

The lighting is a little dark in the picture but this will be a lovely/bright kitchen and living room for our next resident.

@Luis Cerwin as others have stated, Nov - Jan is the worst time of year to have a vacancy.Majority of tenants live paycheck-to-paycheck, so all their income goes to Holiday spending starting with Halloween, then Thanksgiving, then xmas, then NYE.January is also historically the worst month for rent payments due to Holiday Hangover Spending.