Its hard to say, considering we don't know your comparison point: looked through lots of small refractors, binoculars, 6" scope, etc...
The 10" is a great choice in that its right where you start to get enough aperture to get after the tough stuff. It also is enough aperture to start to resolve globular clusters.
A comparitor: M11 and M22 are the two finest globs visible from North America. I can see both as faint blotches with my naked eye and averted vision. With my 10x50 binoculars, the are large grey patches. With my 4.5" telescope, they are large, bright, grey patches, with single points of stars visible around the edges. With my 10" telescope, both just EXPLODE into a see if individual stars.
You want a one word reason to buy a 10" over anything smaller??? Globulars!!!
Bright things like planets show more detail in the bigger scope, but I've found that more often than not, the qualities of my views are usually limited by the atmospheric conditions at the time and not the size of my scope.