Admittedly none of these teams are my home team so I don't know how each fanbase would feel about it, but from an outside perspective it makes sense to me.
Portland is able to trade Dame to the team he wants AND unload Nurkic. While I do think this trade makes them worse immediately, it still nets them a young, improving wing that is not really a logjam with their young guards (I see RJ Barrett as a 3/big wing rather than a 2 so there isnt too much overlap with sharpe), another wing in martin who showed more to his game in the playoffs, and an expiring lowry contract who can actually be a mentor to the young guards without demanding the playing time that Dame would. A starting lineup of scoot, sharpe, barrett, grant, and a 5 TBD seems pretty fun to me.
Miami obviously gets Dame which on its surface is good enough already. However Nurkic could be more than a throw in for them. While Bam is more than good enough as a smaller, mismatch 5, he does get overpowered as the lone big man far too often. I think it'd be great to have a reliable true 5 on the roster to start next to Bam, or play primarily as a backup and only play next to Bam when needed. Dame more than makes up for whatever offense they lose from Herro, and the 2 spot can become a spot thats filled by committee as Miami has shown in the past they are able to do.
New York gets in on this to try and juice up their offense a little more. This can be seen as a lateral move by some, but I think the difference in offense creativity and creation between Herro and Barrett is actually pretty substantial. This gives New York a true 2 guard to play off Brunson and efficiently create when Brunson needs a breather. It also allows new york to search for a true big wing without feeling like they'd be overlapping with Barrett.
Honestly, I don't know what picks would need to be thrown in and from who to who, but from a player perspective, this trade makes a lot of sense to me.