If the ball stays together even when tossed you must have some clay in
it. Now, if you take a few tons of organic matter, and put it into a
bed and wait say three years, that organic matter (with the exception
of large wood chips or other slowly decaying stuff) will look the way
you describe it, smooth muck with some native soil in it, courtesy of
the earthworms which churned the bed several times in those years. It
will still be good soil, call it a loam with high organic content.
Your own compost looks the way compost looks after six months or so. My
compost beds (up to eight years old, entirely filled with organic
matter) look like muck, with a bit of sand thoroughly mixed because I
have sandy soil underneath. The soil is stiff enough that you can make
a ball. As others have said, many nutrients will be gone in compost
this old, in my experience mostly nitrogen, and need to be resupplied.
At that point you have enough humus in there that you can, by and
large, fertilize chemically. And it is soil that drains well and has
good water retention.
This sounds pretty close to some bagged compost I bought once. As it
turned out it was steer feedlot compost and was pretty heavy. Parts of
it still smelled pretty bad but in a day or two that went away.
There is quite a bit of questionable compost on the market. My last
truck load sprouted a huge crop of weed seeds so it was never heated
We do have a municipality pretty close that composts its leaves and tree
trimmings with sludge and it is real good for ornamentals.
Keep trying my friend. Sooner or later you will find a good compost
vendor. It is a pretty good idea to go visit the compost yard to see
what it looks like prior to buying if possible. I have found great
stuff all the way down to weedy stuff. But all of it had some value as
a soil conditoner.
I too have made my own but can never make enough.