Amsterdam will take the cream of the US based tech companies, Ireland will continue to be the ops centre for EMEA and Spain will continue to get most of the contractors.
I think Amsterdam will get much of the London-based business because of their (relatively) lax labour laws (closer to UK) and the facility of the natives with English (important for relocating execs and their family).
There is a massive housing shortage in the Netherlands, isn't there? I agree on your other point but might be logistically complex and expensive v.s. Berlin for instance.