Questions: Shopping & Gifts

What are your experiences with them, or do you know of anyone who has had one, and do you have any tips and recommendations?

I've had fish bowls and small freshwater aquariums but never a saltwater one.
My husband has always wanted one, and we might invest in one.
He's responsible and cleaning the tank won't be a problem.
I have chronic moving-nightmare dreams, but realistically we will probably be staying in this apartment for years (we hope) and so moving a tank is not a problem right now.

I'm in a rental apartment. Have contacted the property management firm and am still waiting to hear back from them whether they will allow it. He obviously forgot again. Have to email him again. But they just raised our rent so we're more likely to get the tank now.
I do have renter's insurance, in case of damage (although I don't know if aquariums are covered. Have to check that later.)

One time, we were sitting there in the living room watching TV and out of nowhere, our glass aquarium just came apart and the water and fish went everywhere. Really strange. I distinctly remember it was a very standard, basic, aquarium. I paid $9.95 or $19.95 for it from Petco or Petsmart, if you're familiar with those stores in the U. S.
So since I know that can happen, I'm concerned about getting a tank. It was just a normal tank.
And we've experienced a massive flood in our building so water is definitely on the brain. It's a bit of a risk.

The reason we want saltwater is for the different fish species. Been down the other road before. Want more colourful this time. Big and colourful. Lots of coral and types of fish.

P. S. I don't like purple. Why are so many search results for 'saltwater aquarium' coming up purple?