I only started following MotoGP 4 years ago, so don't know all the history. Why was the 800cc area so bad? I'm also not the most mechanically minded person in the world
It's complicated, and a historical recounting of events would not really recreate the zeitgeist of the era.
The 990s were well received by most fans, and the competitive landscape strengthened continuously, leading to one of the most entertaining and dramatic seasons in 2006.
For 2007 the GPC made changes against the wishes of fans. These changes were technically dysfunctional, and they were made on the precipice of the global financial crisis. This caused Dorna to assess the MSMA as incompetent. Dorna formed an alliance with IRTA to gain control over the GPC, and they stopped collectively bargaining with the manufacturers. The tire war disintegrated. Cost controls were introduce. Kawasaki withdrew. Suzuki stopped caring. Ducati made some missteps.
The political strain on MotoGP, and the financial strain on Dorna led to questionable decision-making as the sport emerged from the global financial crisis. Five manufacturers had 800cc engines and Ilmor had built an 800cc engine as well. In my opinion, the tech regs and tires just needed to be stabilized. The CRT concept or Open concept could have been done with the Ilmor engine playing the role of DFV. Unfortunately, Dorna wanted to feed red meat to the rabid fan base, and they were still haunted by World Superbike. Dorna opted for a clean sheet 1000cc formula with CRT satellite teams and concession and much more. The following year, Bridgepoint acquired World Superbike, and Dorna no longer needed to worry about Superbike performance comparisons.
All of the discord, abject failure and unpopular changes in MotoGP were blamed on engine displacement. That's why fans are generally spooked about the 850cc formula. Anything that starts with an 8 is suspect. But the total dysfunction from 2007 to 2014 or so was obviously more complicated than cc's.
Regarding 800cc racing, the beginning of the 800cc era was decent. Stoner won easily in 2007, but Rossi took a few signature wins, and there was good back-and-forth between Bridgestone and Michelin. Suzuki were competitive for the first time since the 500s, and Kawasaki were also improved. Unfortunately, the excessive tire performance and the impending financial crisis would crush the 800cc era. The smaller teams withdrew or stopped caring. The races became processional snooze fests.