I always liked the idea of "Real Robots" doing battle with Eldritch Creatures.
Can I interest you in a little game called Mecha Knights: Nightmare? It's not transcendant, but still kinda fun. It's essentially about hell titans released by Russia. Kinda hard, I got filtered early.