I guess I'll be the closest to saying yes. While in the middle of a delayed trade from a 2305 to a 1026R my dealer kindly provided a 3XXX series tractor as a loaner. They had committed my 2305 to another costumer but the 1026R had been delayed...
I counted the days until the 1026R came in. Not only is the 3XXX bigger, but of course all the implements were too. I couldn't fit it all in my tracter shed (which isn't tiny at 20x20). The tractor had a higher CG (nothing Deere beats the 2305/1026R there) and was less stable on my property, which is all hills. The tractor was too tall to mow under my yards trees and too large to maneuver in my smaller areas. It felt like I was driving the loader by remote control (sooo far away *grin*).
Basically, with the exception of they few times I've needed units 10x the size to come in (finding a couple ton rock just barely poking its head up in the drive), I really haven't needed/missed the extra power and size of a larger tractor yet. I know I don't have a large property compared to most here and don't use the land/tractor professionally, but for my uses and needs anything bigger would just be more money, space, and height (with less flexibility).
My overall thought is that people would be foolish to ignore the prevailing wisdom of getting more that you think you need, it's "prevailing" for a reason (increased PTO and pulling power, lift height, lift capability, hydraulic flow, etc). On the other hand there is such a thing as overkill and bigger does have downsides (increased storage requirements, initial cost, incremental cost for every implement, fuel usage, maneuverability, weight/compaction). In some cases like mine the upsides are really limited and the downsides do outweigh them.