Hi, before you think about specific brands or manufacturers, you should decide on a rough geometry.
In the worlds of road bikes, those are mainly:
- Race bike: very aggressive geo, often with aero features "low and long" aka low stack and long reach
- Endurance bike: higher stack and shorter reach, makes for a more "relaxed" ride
- All-road bike: similar to and endurance bike but allows for (even) wider tires. Bit of a crossover to a gravel bike. Makes rides on rough terrain more comfortable
If you want to race (often), you might want to look into #1. However, the geometry can be uncomfortable, especially for beginners and if you lack general fitness and flexibility. You can practice (and get in shape) to be more comfortable on this type of bike but "comfort" is never a focus on these. They are meant to go around a track as fast as possible. Whether you are comfortable while doing so is not a top priority

#2 is a geometry that's usually more sensible for recreational riders. Especially, if you wanna do tours longer than 2-3h. That being said, I regularly do tours of 5-8h on a race bike as well. You are a bit more upright than on a race bike and - again depending on general fitness and flexibility - your body especially your back with be grateful for it. This doesn't mean you can't go fast or even race on these bikes. Many hobby racers do. You might just miss out on a few marginal gains. But in this class of racing, your general fitness and power will decide the race much more than a few watts saved by aero features.
#3 the "real" do-it-all bike. If you wanna take your road bike off the paved roads from time to time (aka light gravel riding), this might be something for you. Geometry is usually similar to the endurance bikes but they allow for a bit wider tires. You could even opt for 2 wheel sets: one for road riding/racing with fast tires and another one with wider gravel tires for your bike packing/gravel touring demands and added comfort and stability on uneven terrain.
I probably missed another "category" but I think those are the most common ones. And they aren't clearly defined. Frames overlap and might be in-between two categories. But these can help you decide what is most likely the best general fit for you.
Let me know if this was helpful or if you have further questions. Once you decided on a frame category, it makes more sense to look for a specific brand and model.