I dunno, I've been around awhile. While Star Citizen is going on a lot longer than some of the below, these are some interesting reads down the google hole if y'all have some time:
- Atari's E.T. is probably one of the most famous ones and one of the most talked about
- Daikatana and the entire Ion Storm fiasco, including John Romero spending millions and millions on office furniture and uh some other crazy stuffs
- Duke Nukem Forever and the entire swampy mess of redoing stuff constantly
- Final Fantasy XIV's original release, although the comeback was quite awesome
- Kingdoms of Amalur the unreleased MMO and its shady tax payer funneling
- !NSFW! Illfonic's (yes, of Star Marine fame) dark "adult" MMO Revival where players bought houses and furniture and ahem dungeons for real money !NSFW!
- Brad McQuaid's (RIP) Pantheon MMO, who have been charging subscription fees since 2015 without any game to play whatsoever
- Shroud of the Avatar and its hilarious problems over the years -- I often wonder if it will get shut down before the crossover crossbow comes out in Star Citizen (Turbulent worked on their Kickstarter as well)
- EQNext and its famous forum "I believe in this project, you haven't seen what they have been working on behind the scenes" post the day before it was completely shut down
There's more, so many, many, many more, including indie Kickstarter games out the wahzoo. I should really put together a comprehensive list one of these days.