I don’t own a gun, so no personal experience but I have a few observations reading through this thread -
First, what are your goals? How important is security vs convenience?
Anything can get hacked, picked or broken, given enough time.
The glovebox with a PIN is quick, easy & cheap and will prevent a smash & grab. If someone’s breaking in to your, I wouldn’t worry about the hack posted above; they’ll just take a pry bar and pop the glovebox open that way.
A plain lockbox under the seat would work - you could fairly easily secure it with a cable to the seat rail.
The frunk is going to be more secure. If you want added security, it’s possible to use one of the bolts to bolt a box or a cable to the frame. If you put the bolt through the inside of the box it will be nearly impossible to get the box out.
The console vault is probably the best combination of security and convenience. If someone has physical access to your car for a period of time they’ll clearly be able to break in, but that’s the case with everything. for the vast majority of situations it should be plenty secure.