In the US there are 2 narratives I am familiar with. The predominant narrative that is taught in most schools is that Russia is a bureaucracy that controls everything without democratic principles like the US has. I am not intrested in that narrative for my question.
The other, which is the one I'm most intrested in hearing the Russian historians' view about, is that the intent of the revolution was to accomplish something like a stateless nation with no Big Brother government and where everyone would be equal, and to accomplish that a Vanguard group would take over control of all the important assets and resources to bring about a stateless nation for the benefit of everyone, but unfortunately the Vanguard group never turned over power to the people. Do Russian historians agree with that interpretation of the historical record or do they tend to gravitate towards a different narrative?
To preface this answer, please understand that getting any two historians to agree on something with as broad a scope as the question you ask is a pretty difficult. Therefore, I plan to present a few representative cases of Russian historians and their general perspectives on the nature of the government of the Soviet Union.
To start, the answer to your question most directly is that the Soviet Union (including any of its progenitors like the RFSFR, the Communist Party, even going as far back as the General Jewish Labor Bund) is/are not generally perceived positively by the educated classes of Russia today. Academia and the intelligencia were among the most persecuted groups during Soviet times-- whether because they disagreed with the absurd pseudoscience of Lysenkoism that was mandated as canon until the sixties, or because they were involved in dissident movements throughout the seventies and onward, or maybe they found themselves wrapped up in one of the many political purges that occurred as new cliques came to power during the nigh 70 year rule of the Communist Party. There were special research facilities called Sharashkas colloquially where scientists were held and forced to perform whatever experiments/research the Soviet government demanded of them. The leader of the Russian space program, and man responsible for the USSR's victories in many aspects of the Space Race, Sergei Korolev, was literally pulled out of a gulag (forced labor gold mine) in Siberia upon receiving a commission (re: order) to perform the research and development that would eventually become the Russian Space Agency and ultimately RosCosmos today. In short, having any kind of unorthodox or contrarian stance on just about anything was a fairly risky endeavor until about the eighties.
The next part of the answer is a qualification of what you consider a historian: Lev Trotsky considers himself a historian (among other things) and in that role even wrote a three-volume History of the Russian Revolution. I'd recommend it insofar as it is a great primary source for the events leading up to the October Revolution, but would similarly advise to take Trotsky's analysis and chronology with a big ol' grain of salt considering he heavily revised his first two volumes, and wrote entirely the third, from either internal or external exile. The same is true for Stalin's writing from the time period-- really great as a primary resource, but also really unreliable personal propaganda from a man embroiled in quite literally, a life-or-death struggle within the party.
Historians such as Trotsky and other sympathizers of the Old Bolsheviks who are already professed Marxists of some stripe (mostly thinking of guys like Zizec and Chomsky here-- though both are critical of the USSR at times) are most likely to harbor the kind of sentiments that you outline in your question: the October Revolution was righteous, but corrupted and oftentimes, this corruption is directly personified by Stalin's assent to power. This is not generally the case with a typical modern Russian historian.
Consider the following examples for further reading (unfortunately most of these guys only publish in Russian):
TL;DR: modern historical thought generally holds the Communist Revolution of Russia to be disingenuous in its claimed intention of the formation of a worker's paradise and that consensus is mostly the same in Russia.