I too found the process of working out where to get stats from and how a little confusing. However I think I've got the hang of it now and the stats I was able to get from the new "detailed" endpoint are much quicker than using the Management UI. I don't know if it helps but I use "rabbitmqctl cluster_status" to get a view of which nodes are in the cluster and if there are any problems, like a node down or a split brain.
I then use the list of nodes from there to know where I have to go and look for Prometheus stats, that gets uploaded to a DB where I can run reports or issue alerts.
As I say, I'm very pleased with how much faster this is than having to scrape the Management UI. If I were to wish for anything at the moment it would be for a list of current connections open by users. Getting it from the Management UI is either slow or it just hangs (at least for me) so if that were available from Prometheus it would help.
Cheers,
Matthew.