
ASICS
SUPERBLAST 2
Marathon workhorse, but loud and clunky at slow paces.

Running these analyses costs money. Buy through my links to help keep lights on! I may get a small commission.
Asics Nimbus. I have the NB More and the foam deformed, SL are very good for running but my thinking is that for standing is not a good choice
New Balance VMores were my go to.
If you want something soft, try New Balance More or 1080. And for the knee issues, I would recommend seeing a physical therapist.
New Balance. Fresh foam, to be specific. I've had mine for 4 years now and they're looking a little rough but I will wear them until its last shred. They are now my walking shoes and I feel like I'm walking on clouds and can walk all day in them vs other sneakers that I've gotten since (Vionics, which are okay imo and On Clouds, they suck). When my NBs no longer had the training mileage left, I ended running a marathon in Saucony Triumphs, which are just as comfortable. I've been keeping them away so that I don't ruin them outside of running but maybe it's time to take them out once and for all.
I used to work at a sports medicine podiatry office, probably the most recommended shoes were the New Balance Fresh Foam x More and the Hoka Bondis, and Brooks Ghosts. Second going to a DPM and get scanned for orthotics! You don't have to be an athlete to go to a sports medicine place by the way! They usually specialize more in mechanics (vs a conveyor belt of corns and diabetic ulcers), and most of the time they just want to do whatever they can to help you stay active in the way you like. You can call your insurance to see if there is a benefit for orthotics (If you are in the US anyway, the code is L3000), or they might offer a discount if you don't have one. They can be expensive but as someone who just kinda assumed foot pain was part of working out they can make a night and day difference in your life.
I mean yeah, it could be due to the foam compressing under your weight. But having run many shoes in the NB line (1080 and More are my favs) their shoes are more like 300 mile shoes. I can easily put 500 miles on most Brooks and Asics models. Superblast 2 would be a good fit for you. Those things are tanks. I'm hard on shoes and I couldn't kill them. I rotated SB2 and 1080 v14, no comparison. The ride was firmer for a high stack, but very protective on those Saturday marathon training runs.

ASICS
SUPERBLAST 2
Marathon workhorse, but loud and clunky at slow paces.

Nike
Vomero Plus
Ultra-comfortable for long runs, but too bulky for speed.

Saucony
Endorphin Pro 4
Stable race shoe, versatile, but narrow fit, lacks bounce.

ASICS
Megablast
Very durable and versatile, but narrow toe box, causes blisters.

Mizuno
Neo Zen
Plush and versatile, but can be too soft and unstable.

Ranked #1
Brooks - Glycerin GTS 22

Ranked #1
Puma - Velocity NITRO™ 4

Ranked #1
ASICS - SUPERBLAST 2

Ranked #1
ASICS - SUPERBLAST 2

Ranked #1
ASICS - SUPERBLAST 2

Ranked #1
Nike - Vomero Plus