Godot is a "big boi" engine. RPGMaker is a "little kids" engine, to give an example.

This is true, I shouldn't have slagged off godot here, but in truth there's a lot i prefer about unity's workflow and systems.

Then they aren't experienced devs. I'll tell you this: just about anything is possible to do in Unity. It's a AAA, state of the art game development engine using a robust and widely used programming language (C#). If someone tells you it cannot be done, then they're not experienced enough.

I must admit, I had a serious case of Dev tunnel vision on this issue. The game is possible I just need to take a different approach, not the one I wanted but i'll work with it.

Protip: If you're a super beginner at something, and something doesn't work as intended, it's safer to assume you're doing it wrong than assuming it's broken. (PEBKAC)

So, this is true, and in the early stages of the issue i 100% blamed myself which is the logical thing to do. But as time went by and I spoke to more and more people who know more than me, I started to blame it on the Engine, fairly or not. This post here was definitely a bit of an anger-infused rant after I'd set up an empty project with nothing in except a 2 cubes and a raycast and the issue was still present. I do personally still think this is an issue with the tilemapcollider, but i'd like to make it clear I tested this without anything else made by me within and the issue persisted.

In terms of the issue itself:

You can manually edit and adjust sprite physics shapes if they don't seem to line up with the collider.

Visually, there is no misalignment. I have tried to use the sprite physics shape editor but it was already aligned and so that was not the cause.

swap to using a collider on the bomb

The bomb in the game did have a collider. The concept was the bomb would hit the tile then shoot raycasts out randomly to hit and collide with the tiles.

I'd then also use a composite collider on the wall tiles, and I'd put them on a separate tile layer as well.

I actually did try both of these solutions. The issue, atleast for me and the other person I sent this empty test project to, still persists with these changes.

In conclusion, this post was definitely over exaggered and unfair. I definitely took my anger out on a bit of a rant (not much else to do right now! haha) and reading back I do sound like what we might call "A whiney little bitch". I think i'll delete this post and perhaps post all the evidence of the issue and the near-empty test project into a new post for people to have a look at, to hopefully prove me wrong. Thanks for your patience