As someone who enjoys TW style games TW:WH is absolutely excellent and a wonderful time.
While the DLCs are expensive the base game has a good chunk of content already and you don’t really need to pick up the extras to get hundreds of hours out of it. It’s very much a situation where you should only grab things as they interest you or splurge during a massive sale.