> Does this somehow open the door for smaller teams to create games that involve photorealism

Yes, less dealing with LODs using nanite, less worry about drawcall count, less budgeting tri count. And Epic provides huge photogrammetry scan libraries that work well with it.