No argument with what has been said already about dslr etc., but think about the how what and where of using it.
My beginnings were with film cameras, pentax slr mainly, ending up with the MX. I can remember kodachrome 64 arriving and giving you 3 full stops more to play with compared to kodachrome 25. First foray into digital was an awful thing that came free with a dell laptop just after the turn of the millennium. Then a bridge camera then pentax dslr, all the old k mount lenses are still compatible in manual mode. Happy.
But then as I edged towards retirement short trips to Europe and wanting to stick with hand baggage became a factor. Got myself an early Sony Rx100, about £300, late models come in close to £1K which seems far too much, pocket able and good for any on screen viewing. Can fit filters and has full manual control if you want it. Never carried dslr again, even on a 4 week trip to NZ. Still use it at home, rarely, for macro and some copying work.
The Rx100 m2 version serves me well and I don't think buying a newer shinier version would give me better pictures. But now I've got a Huawei p30 phone and the Rx100 rarely goes out. I skip up mountains instead of trudge (well not really but you get the idea)
If you plan to go out specifically to take photos and have patient companions a dslr is great, take your time, wait for the light, carry a tripod. At least its better than full plate and Ansel Adams mule-transported kit. There are times like near an osprey nest in Scotland last year, when all the kit would have been great. But 99% of the time taking pictures is incidental to what I am going for so carrying less suits me fine.
Phones have very clever software which goes some way towards mitigating the small sensors. My P30 has 3 lenses including a 135 equivalent lens, the P30 Pro has a periscope lens that goes to about 210. It doesn't match a proper camera, but you always have it with you.
Maybe carry a gift wrapped brick around with you for a day or two, thinking "would I be happy with this as a camera". Think about how you travel and spend your time (Covid aside), I like being able to go away for a few days with just a small bag. Then decide if its dslr for best quality, good compact as half way house, or what.
The best camera is the one that fits your real world needs. I bet there are drawers full of little used kit all round the country.