I was going through my 20 favorite courses. Between them, there are about 5 holes (excluding par 3s) where hitting driver isn't a realistic option for me. Among my 20 least favorite courses, they average between 2 and 3 such holes apiece.
In my experience, the courses with the most interesting tee shots are the ones where the strategy isn't a question of whether to take driver or lay up, but instead a question of how boldly to play with the driver. Questions like "Do you try to carry the bunker or play around it?" are more interesting to me than "Do you try to hit driver into that narrow spot, or lay up to the fat spot with a hybrid?"
Of course, to present meaningful options for bold and conservative play with a driver, a course needs a modicum of width and angles that matter. After all, there are plenty of wide open courses where you can hit driver all day without much excitement. It's a bit of a chicken-or-the-egg question. Are courses good because they present the option to hit drivers? Or is the option to hit drivers a by-product of courses that are good because they have meaningful width?