Long-term comfort for your feet comes from biomechanical support, not cushion. While cushioned insoles may feel great for a few days, they don't correct the causes of feet pain or prevent bio-mechanical issues such as overpronation.
No matter what type of arch you have, there's an orthotic insole that can help you with many types of foot pain. First, you need to know your arch height. If you don't already know, there's an easy way to find out.