I didn’t find him particularly scary in Insomnia, but he was believable and his character had depth which meant a lot more in the context of the film.
Insomnia is still a bit underrated, buried in the larger Nolan canon. It’s an incredible and inventive crime drama, but probably (one of?) Nolan’s weakest. Which is to say it’s broadly only like an 8/10.