As metatarsalgia is such a bad term and is not a diagnosis, it is not possible to give any sort of shoe recommendations for it as it is due to so many different things. Some shoe advice could be given for the different diagnoses that get mislabeled as metatarsalgia.
For example, if its a stress fracture of the metatarsal bone, then a shoe with more cushioning might help.
If its due to fat pad atrophy, then a shoe with more cushioning will definitely help.
If its due to a pinched nerve or a Morton’s neuroma, then a much wider shoe will help.
If its due to a plantar plate tear, then a more rigid shoe or a shoe that has some sort of rocker under it will help.
Can you see why it is impossible to give blanket advice for shoes for metatarsalgia? It all depends on what is causing the symptoms and the shoe recommendation will be different for different causes.