Woah I’m dealing with this right now too, (2022 MYP) sounds very similar, and driving me bonkers.
Baby on the way and if I can’t solve this it looks like the car has to go, wife says it’s too “rough of a ride”, I agree with her.
What’s weird is I just got adjustable shocks / coilovers installed to get a smoother ride overall, and then this started (it wasn’t there before!) so any benefit of the coilovers / softer setting shocks is hidden by this crazy rattle / thump on every bump.
Took it back to the shop that installed the coilovers and they swapped everything but the spring out on the rear right and it didn’t change the issue, they spent two days working on the suspension and claim now it can’t be it.
I have a hunch it’s the panels under the car, and as of last night my crawling around under there I can see a few bolts missing and you can shake the wheel well panel, and it makes a similar noise. This weekend I plan a complete tear down back there to see if I can find it, wish me luck.
Did you ever solve yours?
Now to find out where to get some replacement bolts for these panels.