Wow a lot has happened in here! Thanks everyone for the feedbacks. I've been reading all of them, and for sure Tahoe felt like a painful upgrade. I could downgrade, but it's a lot of work considering I've already spend a day resetting a reinstalling MacOS from scratch after a failed Tahoe update.
I will drive through the different options for a new Mac, and wait next week presentation.
I've been considering the Mac Mini as it is extremely cheap for what it has to offer, especially today with the Memory/RAM inflation. Since I have all my files synced on iCloud, working with my MacBook on the go, and on the Mac Mini at the office could absolutely work.
Not that I don't want to buy a Macbook, but outside of being very much more expensive (it's a all-in-one package in the end), I really don't enjoy the bulky design and the notch on the current lineup. As it is an investment for years to come (7-8 years at least), maybe the next design will be worth the wait, at least for me.