Nope. Nothing will make HDDs great again: they will ALWAYS be flawed from conception. Why? Because they're mechanical.
Given that SSDs are faster, don't have moving parts to suddenly screw you over, and are coming down in price, it makes ZERO sense to regress the other direction.
The only thing that Optane sticks (The NVME ones, I'm holding judgement on the RAM sticks) are good for is making 1-2 year old computers (so that they have an m.2 slot) that are super low end and already feeling slow feel a bit faster.