I would stay away from big marshmallow shoes like Hoka, CMP, etc. It is too big of a change to try those shoes in the middle of training for a marathon. I am also skeptical that these shoes do anything and have concerns that they can cause more harm than good due to adaptations that you may make in response to being higher off the ground.
And I would also just stay with what is working when in the middle of a training cycle for your first marathon. The adjustment your body will need to make to keep up with the increase in mileage is more than enough. You do not need to be throwing different shoes at it.
Unless you are going for a time goal that is close to 3:00 or faster, I would just wear your same training shoes when racing. Just be sure that they are a newer pair. Most people should have a goal of just finishing strong and not going out too fast at their first marathon. Don't worry about super shoes or racing flats the first time out. Just run a smart race at a comfortable pace that will let you finish strong instead of bonking and walk/jogging the last few miles.
Finally, unless you have some special orthopedic issues or have struggled with injuries, the best running shoe is whatever feels good to you. All the stuff about matching foot strike, running style, etc. to running shoe style is pretty much a bunch of marketing BS. A stable shoe that does not bend easily when you try to twist it by holding the toe in one hand and the heel in the other is generally a good shoe for any runner who is just getting into it. As you log more and more miles and get faster, you can start messing with racing shoes and the trainers that have more flex or get you up higher off the ground. But honestly, I have known a bunch of pretty fast guys over the years and almost all of them just find a trainer they like and stay with it.