If it's a decent concrete lintel, an ordinary hammer drill will struggle - but an SDS drill will go in as if it were cheese.
Yes, I've still got one of those - and it sometimes comes in handy for small jobs in confined spaces - but the batteries are old (I've got 2) and don't hold their charge for long.
As I reported a few month ago in another thread, I've also got a 12v drill whose battery died so I removed the cells and fitted a cable terminated in a cigar lighter plug - so it can be used in a car, or with a portable power pack.
You may not use it all that often, but you'll be glad of it when you *do*!