The cheapest collider is a Sphere, followed by Capsule, Followed by Box (Which are Mathematical)
Then there are the non-primitive forms of collision, like Convex, and Non-Convex(Complex) collision (Which are Geometry based)
Spheres are the cheapest form of collision, because the mathematics involved in determining if an object is colliding with a sphere, it’s actually done solely based on distance to the centre. Sphere collisions (Despite how they might look in engine) don’t have any polygons. They are a mathematical concept, a primitive.
Capsules are similar, except the distance is checked against a line inside the capsule that represents the inner most portion of the shape. So there is a slightly larger degree of complexity. You’ll notice that when you control the parameters of a capsule, you’re only controlling the length of that line, and how far the surface of the capsule is from it.
Cubes/Boxes are the most complex of the 3, because there is simply more complex mathematics at play. Nothing too substantial but it is certainly heavier. The nature of boxes allows them to be non-uniform. Then there is orientation to consider. So there are just more layers to the calculation.
Next up the list is non-uniform convex collision. It has all the properties of the box, but with even more to evaluate and calculate. The expense is generally not too significant, but building your collision from Primitive collision is SO much cheaper than using generated collision.
Finally, we have Non-uniform non-convex collision. Which is so wasteful it’s basically never worth using. It’s always better to use multiple primitive shapes, and build up your collision with them.
For the record, it is ALWAYS good to know these things. As @ThiloN1987 stated, you can end up in a situation where you need thousands of collisions, and only the cheapest will do!
You should never disregard something as important as optimization if you want to work on games. As a hobbyist, something like this isn’t as consequential. But lag spikes, or poor performance will prevent your game from being launched on platforms with high standards (Basically all consoles).
Despite significant technical advancements in game development technology, things like collision are still very important things to consider. They are pivotal for optimizing physics based objects, constructing proper collision for complex meshes, and ensuring your game is responsive and well tuned.
[Update]: Per @AntiGravity 's request: All collision calculation is performed by the CPU, regardless of whether or not you are using Primitive, Simple, or Complex collision.