Example LoadObject<UTexture2D>(nullptr, TEXT("/UnrealPrefabs/Editor/T_PRCSprite_Placeholder.T_PRCSprite_Placeholder").

For a simple engine example see USceneComponent::CreateSpriteComponent where it loads the default sprite texture called “EmptyActor”. You can find it in the content browser.