For a little clarification in terms, your standard drill with a 3 jaw chuck that has a hammer function is known as a hammer drill. The larger dedicated machine with a spline, SDS, SDS+, or SDS Max chuck, is known as a rotary hammer.
The terms illustrate the difference. A rotary hammer is a hammer, with a rotary function. A hammer drill is a drill, with a hammer function.
I've only owned pretty decent quality when it comes to hammer drills, Dewalt brushless and Milwaukee Fuel. I've also used large Hilti and Dewalt hammers and personally own a HF rotary hammer. I'll say this, a good hammer drill with a good bit, is perfectly adequate for small projects doing up to a half inch in concrete or block, and will punch holes in brick easily. They'll do 3/4" slowly. They are far more effective than some have described them to be.
A rotary hammer is far better, but for normal projects the step up to a real hammer isn't as a big of a leap in capability as going from a non-hammer drill to a hammer drill.
I'd push my hammer drill up to an inch or so if I had to do just a couple shallow holes, but I wouldn't even consider trying to do even a tiny hole in brick with a non-hammer drill.
Sent from my XT1575 using Tapatalk