Our house is in great shape - my wife and I have done a lot of aesthetic things.

Don't do cosmetic and aesthetic upgrades to your house until right before you sell it.

. - yard work - 100% need to work on the yard - overall new paint throughout the house - general design and aesthetic things So I’m going to make this a two part question, which of the above should we think about doing from a value add standpoint?

Make sure whoever you hire knows how to edit videos well, has an idea of your aesthetic, understands your audience, and is testing and measuring the results of all marketing endeavors.

I liked the aesthetics of the property.

The countertop is what matters most aesthetically if the cabinets are functioning and painted and there are beautiful preformed laminate choices at box stores.

So, the contractors would have to understand all the building material needed for the ADU, timing, building codes, depth of foundation, beams and brackets to use... etc. and where they would need detail would be: on the finish work: i.e. tile, window type, flooring, cabinets (type, texture, color) etc, anything that would be considered aesthetic (as one tile could be $2 per sq ft and another would be $10 dollars per sq ft) and even choosing one or the other would entail more labor work or less and hence the labor costs could change with every decision made. 

If as a result of your negligence, a tenant injured themselves so severely and at such a high cost for medical expenses, that the tenant's health insurance company's claim against your property policy, and deemed it monetarily worth their while to bring suit against your homeowners policy holder, I would say you have a whole slew of more pressing problems like overcoming the urge to complete your "violent art gallery show" where in you hang running chainsaws from the ceiling of other people's homes in an aesthetically pleasing pattern.  

.), and put the rest of our money to work on opening up the floor plan and adding aesthetically pleasing features to the space.

Location, property aesthetics, amenities, lease terms can all dictate a great deal of fluctuation for the price.