For work on masonry or walls, I would definitely get a hammer drill. However, you should pay attention to quality. Because cheap or no-name drills are often quite weak in performance, and when you then encounter solid masonry, the inferior devices fail. Already experienced that. You don't have to buy one right away. For a few holes in the wall, you can also borrow or rent a hammer drill for a few days at a low cost.