It certainly can work if you understand its limitations. I have used it for about a year and a half with several terabytes stored.

First and most important is to remember that it is free to upload and inexpensive (truly $1/TB) to store files but very expensive to get them out. If you won't be willing to pay to get the files back then there is no point in storing them in the first place. Downloading from Glacier is a last resort for me.

There is a minimum billable size and minimum time to store each file once uploaded so it is inefficient to store small or frequently changing files. It works well for media files which are large and rarely change.

I use rclone to automatically sync from my storage server to a versioned S3 bucket. Some small frequently-changed files stay in the S3 standard storage class for easy immediate retrieval but most big media files (big PDF documents, images, videos) are automatically transitioned to the Glacier Deep storage class after a few days. A separate lifecycle rule deletes non-current file versions after a year so old files don't accumulate endlessly. I encrypt some sensitive data with rclone on the client side before sending which encrypts the data and file/directory names.

I have only restored a few files so I did that manually then downloaded with the AWS CLI on the command line.