America was great 200 years ago.
In 1825 the USA was an agrarian backwater that nobody outside America really cared about, or had much reason to care about, other than as a source of cotton and tobacco, and as a market for African slaves.
The only sense in which America was "great" 200 years ago was in geographical extent, having doubled her size in 1803 with the Louisiana Purchase.
America had potential 200 years ago, but wasn't anywhere close to "great" relative to other nations, or in any objective way other than land area, until her Industrial Revolution in the late C19th, and the Great War in the early C20th. So more like 100-150 years ago.
Of course, it's almost infinitely arguable what constitutes "greatness" in a nation; But while that makes it hard to decide when and whether a nation
is great, it doesn't stop us from being confident that the USA in 1825
isn't (yet).
The first half of the C19th saw a titanic struggle amongst empires to become Great Powers, and to become greatest amongst these. All of the participants had at least a toe-hold in Europe, and the two with the least European territory (Ottoman and Russian) were the most backward and least likely to prevail. America wasn't even in the game, much less an important player.
The New World was seen, in 1825, as a source of wealth and power to be exploited by the great empires, not as anything great in themselves - not even the USA, which had a government unique in her jurisdictional independence from Europe, despite being entirely dependent on Europe as both a source of manpower (much of it indirectly in the form of slaves imported by Europeans), and a market for the cash crops grown by that manpower.
In 1825, Canada was, arguably, "greater" than the USA, because Canada had the benefit of being a part of the British Empire, and as such had better access to investment from wealthy European speculators. Neither North American polity was anything to write home about, though.