I'm gonna chime in only because I recently bought a tractor and thought I'd share my thoughts/experience. I'm not a seasoned vet like many of the folks here, but learning as I go.
I went with a Mahindra 4550 - 50HP tractor coming in at almost 11k lbs with tires loaded and the backhoe on. I sacrificed a lot of the creature comforts to get a bigger/more capable machine (in my minds eye anyway). I have a dealer nearby that I've worked with before on other equipment and Mahindra was offering 7yr 0% financing which definitely got my attention. It has 7 yr powertrain warranty as well. I had my dealer track down an unsold late model ('24 when I purchased in '25) and saved probably $5k in doing so, but still a brand new machine.
There are some things that I like and others that I dislike in my opinion.
Pros: its a big heavy machine with plenty of HP for what I need. Lift capacity is 3500lbs. Backhoe capable of digging out mature tree root balls. It's all metal - so its built pretty rugged. I'm not particularly gentle on equipment and I think it has the physical build to take a bit of a beating. I've been grinding stumps with a 3pt stump grinder which is pretty rough on it and it's been handling it like a champ.
Cons: I sacrificed some creature comforts to go with a bigger rig. Its gear shift transmission which can be annoying, hydro is much nicer to work on. My dad has a 35hp hydro tractor and its much more user-friendly easier to drive and likely safer, but lacks the sheer power that mine has. Mine is basically a newly built tractor on a frame/technology of a 1980s tractor. Everything is analog. It is not a refined rig, but it has been capable.
The tractor is too big/heavy for my truck and trailer combo, but the dealer offers pickup/delivery for serving for like $150 (roundtrip) which drastically reduces the need for me to trailer it - basically nonissue since I live at this property.
I have mixed emotions on my decision. This tractor is capable to do basically anything I need it to, I don't think I will find myself needing more weight/power/etc., anytime soon. However, a smaller tractor with hydro would likely do 90%+ of what I do on a routine basis and do it with a little more grace and ease. Additionally, I think my wife and kid (when he grows up) would be a lot more comfortable operating a bit smaller hydro tractor.
All in all, I think there are going to be Pros and Cons to almost any tractor purchase you make. There will be a give and take depending on make/model/budget. I think it is very important to have a clear goal for what you want to do with it. If light duty clean-up utilitarian use is all you need, a smaller rig will probably do okay. If you expect to run a planter, do land clearing etc., I'd err on the side of something bigger and more powerful.
In my case, I knew I wanted something that was big and powerful enough to be put through the ringer. I've operated smaller utility tractors in the 30-40hp range and I can guarantee I would find their limitations on my property in short order. I wanted something I could "use and abuse" to some extent, but I made some sacrifices in doing so. I don't regret going bigger, even if at times it's a little overkill or unrefined.
I didn't want to pay a small fortune for a tractor only for it to struggle to do the tasks I set out to do with it
*Disclaimer* - I know you're not looking at this make/model or even necessarily this size but I thought I'd share my experience as I recently went through this process. Hopefully it is helpful in some way.