I think anything being marketed will be overkill and over priced compared to a simple doorbell button and MCU combo
What you say you want is just a simple momentary button... so any basic doorbell switch should do the trick if wired directly up to the GPIO of an RPi or ESP8266/32 and retransmit the signal via MQTT to your Node-Red server. Just isolate the switch to the 3.3v GPIO range (AKA don't use existing 12v etc. wiring for normal doorbells) and keep the wire run short. Power the device via battery or USB adapter.