I went the swiss army route back in 2016 with a brand new Kubota B2601 with loader, backhoe and 54" belly mower. It is a great machine and has done a ton of work, including helping me build my barn. However, I really wish I had skipped out on the belly mower and just purchased a decent zero turn mower for the lawn.
The backhoe typically stays off the machine and hasn't seen much use in the past two years. The loader stays on the machine but I drop the bucket when I am using it to mow. I purchased a used power flow bagger for it, but had to modify it to fit around the backhoe subframe and it doesn't work great because of that. Pulling the belly mower on and off is a pain in the **** so it typically stays on unless I am doing a decent amount of earth moving.
For the amount of money I spent, i probably could have picked up a couple of used task specific machines and been way more efficient at the work I was trying to do. I also work for an equipment rental company and have been spoiled by how much better a mini excavator is at digging than a backhoe. If you have never used one, you'd probably not notice it compared to the backhoe, but once you have, there is no comparison, they are easily twice as fast, more maneuverable, and more powerful.
I work with a lot of diesel engines in the equipment world, and I would stay 26hp or less to avoid emissions equipment if you can. If you go bigger I would try to stick with the major engine brands as the systems will require dealer maintenance at some point and you may find trouble getting that type of support from some of the off brands. Kubota/JD/Yanmar(used by JD in their smaller tractors) have good local support typically. Iseki/Mitsubishi/Daedong might be harder to find dealer support for when an emission system issue occurs. DPFs will clog and need to be cleaned/replaced, especially if you don't run the engines hard and under load to get them hot. I don't think you are looking at tractors over 75hp so you shouldn't have any with DEF, but there will be lots of maintenance issues with those systems if youget up to that size machine.
All that being said, I love my machine! It has saved me more times than I can count. It is nice having everything right at the house and available when I need it. Good luck with the search, post pictures when you decide! Hope my post helps a little!