If you want something that is both an acoustic drum VST and that can also easily load your own samples with multiple velocity layers then the best choice by a long way would be BFD3 if you have the money.
If however you only want to load your own samples into some kind of sample player then battery would be cheaper, also in the same price range as battery is fxpansions geist which is a full blown sampler.
Doesn't cakewalks "Cyclone" do that too or is it just a, "one hit wonder"?
Steve