Like you, I have extreme burning pain in both feet (although, one is often worse than the other). I simply soak them in cold water. Not freezing, ice water but colder than just "cool", until the heat is drawn out. I keep a small, portable fan under my desk & by my feet in bed. It seems simplistic & a bit silly, but it stops the pain. I am retired, so I am able to do this several times a day. I even have these soaking "boots" to use in my office, which are less obtrusive than the foot soak bucket I keep in the bathroom: https://www.amazon.com/dp/B09XQQFVKB?psc=1&ref=ppx_yo2ov_dt_b_product_details
My feet are also deep red & look horribly inflamed, but my doctor, vein specialist (I had vein ablation), podiatrist & pain doc have no clue as to why. It started in 2021 with mild redness on the top of my right foot & has spread to both feet & ankles, top & bottom, over the past year & a half. It's the reason I went to a vascular doc in the first place. I guess it's a medical mystery, which seems unbelievable to me. I take 2100mg of Gabapentin per day & recently started taking one 10-325 Hydrocodone in the evening, which doesn't completely take away the pain, but takes the edge off & gives me some relief. I can bear the pain during the day, but after 7-8:00 at night, it's excruciating. I quit going to my neurologist 2 years ago. He would just give me drug samples & tell me to come back in six months. Neurologists can diagnose, but neuropathy can't be cured. Believe me, I feel your pain.