I find the latest BRZ appealing - at least from the performance standpoint - and the new 2.4 NA engine seems great, And it is relatively light weight and correct wheel drive.
I do understand your want for a 4 door, but I think you are grasping at a last bastion and touchpoint of your youth, now that you are a family man. Maybe an off lease bimmer 330i x drive M sport would be more appropriate. Personally, I have been distraught at the inability for me to buy an appealing GM sedan with sports handling package (F41) and a stick. But that era came to a close long ago.
Also in the consideration bin would be the off lease Giulia. WRX have become irritating gen Z Toys.
View attachment 92637