Another specialized knife which bears mention is the Japanese Hori-hori, or soil knife. It coms with a spear point and impossibly dull edges, which can be sharpened if needed. Generally some nondescript stainless steel, since it isn't mentioned as a selling point.

I use mine around the house, gardening, weeding, and the like, and one is going on my next dig.

Also worthy of mention is a pry bar, available in a variety of sizes and shapes, and quite capable of handling tasks which would damage most knives.

Problem with prybars, they are heavy. And they are designed (curved) in a way they are hard to EDC. I wish to have a heavy (not necessarily large, but heavy) knife similar to the japanese soil knife, straight and relatively sharp/dull.

I once bought a cheap 'bushcraft knife' , not for real bushcrafting, but for this reason. It is cheap (meaning: not a very good steal) but it was thick. I wanted it for all around digging, gardening , whatever. Unfortunately since we moved the furniture and stuff around the house, I haven't seen it and don't know where it is.

Rogan Tools https://roganusa.com/

They are going to suck as a knife for fine tasks, but for abusive tasks like digging and prying it'd be hard to beat.