It's true, message buses and work queues have different characteristics. It sounds like you want a work queue, not a message bus. I have very successful experience with using rabbitmq for work queueing, but as you mention there are others too.
It’s much better than Kafka when you don’t know when the consumer will come back looking for what changed
All that said, if I had my time again I’d probably just use one of the cloud providers’ solutions and spend my efforts elsewhere...