If personal anecdote is good for anything, I’ve been using LVM on top of software RAID on Linux for close to 20 years now without ever losing a volume. The last time I lost data was on ReiserFS 3. Like I said, LVM does not protect against drive failure itself. That’s why I use RAID underneath. I’ve got my OS disk to protect against failures like that. Also frequent and verified backups of my data files to make sure that is protected.

And yes, modern (still supported) distros can scan LVM PVs on boot without issue.

LVM Physical Volumes (PV) can be moved between Linux machines without issue (I’ve done that several times), it’s not like hardware RAID where you have to have the same controller on both machines. Nothing I’ve done has ever required LVM metatata export/import.