I've got a 5906 and a 6906.
I've had both of them over 20 years and shot them plenty. They were my carry/nightstand guns from the early 90's through about 2010.
I like them a lot, but not sure it's what I'd pick for a truck/house gun in today's market.
But if it's what you want, they are great guns and I'll give you the perspective of my experience.
The 6906 is an aluminum frame so somewhat of a comparison with a 5903 for recoil and carry.
I did not find much difference in felt recoil between the two so I wouldn't be opposed to the 5903.
The weight difference is absolutely noticeable for holster carry. Plus for the 5903, but you say that's not a use you need.
I'm not a collector but I think the 5906 was far more common.
If so, the 5903 might be more collectible down the road. But it also might cost more today. Don't know.
I would get the winged adjustable sight version. I do like it better than the Novak style, and way better than the fixed non Novak sight they had in some guns.