There are two sides to this topic. Without strong theoretical roots and familiarity with sorting/pathfinding algorithms, you are unlikely to spot the situation where off the shelf solutions are not sufficient. You yourself and your employer might not feel like you are the right person to implement or adapt these low level algorithms. (Chicken and egg problem)

Rest assured that there are projects and occasions where doing this type of work is necessary