Is picking keywords for website still worth the effort?

absolutely, it's how you find out what people actually type, which is often not what you'd call it yourself. The approach has changed a bit though: target the topic and intent of a page, not one exact phrase repeated. One main keyword per page plus the close variations is plenty.