Huginn is much more like IFTTT and is much less visual. It is more focused on creating connections between cloud applications.
Whereas Node-RED is a more generic code platform. It is focused on enabling low-code development of compute tasks with a large (but certainly not exclusive) focus on IoT.
Node-RED is a great way to get some compute logic going without having to worry about a load of boilerplate code (getting a web server going, handing errors, linking functions and modules and so on).