Finished it last night, so I'll add my 2pence.
Visuals: Excellent, there is certainly a step up in texture clarity when going from the BS map to the FW map. Everything looks way better and sharper in BS. The world of BS (Los Angeles) has a ton of verticality to it and it is gorgeous to fly through. All the other worlds we've played are mostly flat whilst LA is much fuller. Sadly I wish it was more populated since it is mostly sparse. It has been a while since I played the game so seeing a Balanced graphical mode (40fps?) was most welcome and the nicest out of the 3 settings as it was fluid and detailed.
The cloud tech Guerilla were boasting about is stunning to witness but I believe it is used in only one small portion of the map - where a certain large mob is located on an island to the west.
Story: There is about 8-10hrs of gameplay here, with a nice return of an old cheery friend bundled into it. Seems that todays touchy 'gamers' are all upset about Aloy's sexual orientation to bother about the gameplay so they're review bombing it to death. The new mount and a battle with a certain Chariot class big bad are pretty much incredible, and my PS4 Pro would certainly cry if the latter was implemented on it.
Combat: Still an absolute clusterduck. The DLC expands the skill tree with new skills that most will never use because everything is just over complicated now. I bought some new legendary weapons, upgraded them and then realised I couldn't be bothered learning how they work because I want to return to Days Gone again.
We don't really get any further development leading towards Horizon 3 I feel but either way it is a good bit of DLC for the price. Sylens will certainly be missed