I’ve had both a 4BW and a 991.1 and a 991.2, with 997.1 and 997.2. All manual 4S. Great cars but if something needs fixed or worked on, your gonna pay. All of these 3.8 motors can bore score. The 3.0 turbo motor does not so far. but the maintenance schedule is pricey, every four years plugs, filters, fluid flush and more. It’s expensive as the labor to get all all that stuff, makes costs go up.
If it’s a second car, great. If not then carrying people and things gets hard.
They will hold their value, long as you have all receipts and can prove it’s up to date on maintenance.
I traded a 991.1 C4S for my BW, as I wanted 4 years of warranty and needed space to take things to my house in Mn, a 1200 mile drive.
So get one, have fun, keep it up on maintenance and when you get rid of it, you won’t lose money.