We cannot got nice details for huge sets, We need to split UV's in UDIM for that, I am working in Animation industry nearly about 3 years now, and I find that UDIM is a great for sets...
For game engines I heard about Granite or something which is 3rd party plug which give us ability to transfer UDIM's into game engine I dont know about Unity but for unreal yes. it is posible.