I don't have a Hope hub at the moment but my Mavic one is pretty loud. I find it handy, coming up behind someone it's a way of letting them know you're there without having to shout (or without having to be extra super cool and having a bell).
Plus you can imagine yourself riding the trail with a swarm of angry insects for company.
I love a near-silent freewheel. I don't think I'd be able to live with the noise from Campagnolo freewheels for example. Way too loud - it just sounds like energy being wasted to me. Hope ones are probably no different.
Click click click means that you're not pedaling hard enough
The 40T Pro2 EVO is much quieter than the older 24T Pro 2 EVO hubs . I have both.