I did naht hit her I did nahhhhht oh hi Mark

"The Room" by Tommy Wiseau

tommy wiseaus "the room"

https://en.wikipedia.org/wiki/The_Room

an unironic favourite film of mine due to its surreal qualities. it often ranks among the worst films ever made, and its definitely not good. but it is unlike anything else in this world. tommy wiseau is a truly strange human being who has lived an odd life, its the type of film only someone like him could make.

wiseau also wrote a book about himself, which then inspired a parody book about his life, which then resulted in a parody film about his life and that book and his film "the room"

https://en.wikipedia.org/wiki/The_Disaster_Artist
https://en.wikipedia.org/wiki/The_Disaster_Artist_(film)

1.) koishi komeiji's heart-throbbing adventure

2.) https://www.youtube.com/watch?v=eYklrgySAd0

a lot of FMV games tend to be unintentionally insane or surreal due to the conflicting art styles and hammy acting, some greats that i love:

https://proxy.yuanyoumao.com/app/501990/Phantasmagoria/
https://proxy.yuanyoumao.com/app/377070/Noctropolis/

others like "harvester" are purposefully satirical so it may not fit the criteria you are looking for, but its debatable how much of the cheese and oddness was intentional and how much of it just ended up being that way due to how mad the game is overall.

https://proxy.yuanyoumao.com/app/287020/Harvester/

shenmue 1 and 2 absolutely are both unintentionally and intentionally eccentric and insane, but i lean more towards the former. much of the insanity comes from the hilariously awful english dub, and the at the time western spheres lack of exposure to much silly japanese humour.

https://proxy.yuanyoumao.com/app/758330/Shenmue_I__II/

shenmue 3 also qualifies, but it sort of embraced the meme a bit in that title. so its much more intentionally insane.