I am a strong supporter of Nodered as it adds much that you cannot do easily in HA Automations.
- Manipulating data
- Creating arrays from multiple sources
- Creating new entities and attribute lists
- Originating data where there is no applicable integration.
- Sending data to an outside endpoint
- Simplifying functionality
- Experimental work
- Automation made simple, but for me probably the least requirement
I could go on, but you would drop off to sleep, but I really could not do without it and at the very least I could not have achieved what I have done so far in creating some fairly impressive data in HA.
I say have a go, you have nothing to lose and everything to gain.