There's a website that has "post mortem" reports on various games... both failed and successful... where they go in to great detail about each game's design flaws and incorrect thinking during the design and development processes.
I believe that site is Gamasutra.com... (does a quick search via google)...
With your permission, GameDev.net uses analytics cookies to understand how people use the platform.
You can accept analytics or continue with necessary cookies only.
Learn more