I bring no great level of expertise, but I will note two things I've observed:
1) I buy a certain size tractor in order to be able to safely do various things. Most dealers tell me this is the right size; one says I could have gone slightly smaller, another tells me I have to go a size larger for round bales. I use the tractor for a while - 82 hours now - and I find it works easily for all the tasks I'm doing, no real issues in terms of size or strength. Then I keep reading here and see various people doing all the same tasks with 2/3 as much tractor. Sure, mine probably does it a little more easily, but it clearly is being done with less tractor.
2) Now step away from US market. We are used to big equipment. If you start reading up on farming around the world, you'll find in many cases our "homeowner" tractors would be full size commercial production tractors in other countries. I suspect this may be why there are so few US-made CUTs. I wouldn't believe something can't be done until you find it can't be done, and it still can't be done with advice from other people. I would, however, be very mindful of safety considerations; for instance, pulling carts or handling round bales on slopes - there, you want a greatly oversize tractor for safety.