The only fuckwits who "harmed" the Dreamcast were the people working at SEGA.
Some gaming publishers were "fuckwits" to be honest
The people working at SEGA during the Saturn era did fuck up Saturn. But the DC was agreat execution. Although I have no idea what SEGA was thinking when they released the DC with just 1 analog stick (and if I am not mistaken just two triggers without shoulder buttons?)
the console was flooded with AAA games and had a very very succesfull launch. It deserved to live longer but it died prematurely for reasons not necesarilly blamed on SEGA. SEGA couldnt do anything to save it.
The DC was probably the first console to have an online service and the hardware was online-ready. It also provided 50hz-60hz options for most games whereas the PS2 didnt except for a few. It also had VGA support. The PS2 never had any.
The Playstation brand was a monster and the console promised better visuals along with next gen versions of its most succesful franchises whereas the DC started out fresh. Games like MGS2 being shown on PS2 at E3 killed all expectations for DC standing up against Sony's visual and physics capabilities.
Piracy, media and lack of support by huge publishers such as EA meant the console would miss lots of important franchises. It didnt see a single Fifa or Need for Speed release.
Anyways, since I mentioned MGS2, that game was super impressive due to its crazy detail to physics and interaction. Water, rain, air, ice melting, bullet proof shields reacting realistically to bullet impacts, impressive AI etc. MGS2 even had bullet speed calculations. I have yet to see a game on the current gen consoles that have set the bar as high as MGS2 did back then.
I am not really sure if they can indeed set new standards. Do they really pack the processing power to unleash physics and interactions that make the worlds more believable? We have yet to see such a game