Tough to say if it's worth it or not. A lot of people hate to admit that they hold cards on the principle of huge financial returns, but don't actually pull the value they thought they would. However, some people will pay for an experience they feel is a more premium one.
Honestly, if you travel with Hilton somewhat regularly, it's rarely a terrible value. However, even though it isn't hard to exceed $450 in value, it causes some people to spend more than they would. I'd say my starting point for the Aspire is the resort credit. Besides the obvious $250 amount, I think that's the point if you are bought in enough to pull in significant value. I know the free night has its allure because it could easily exceed a $450 room, but it may not always work as intended either. Diamond F&B credit is a good addition, no matter how many people scream and cry that it isn't steak and eggs in new york.
Some people are better off not staying loyal, and/or looking for the best hotel for the price.