I have suppressors in 9mm and 22.
Obviously, there are a wide variety of suppressors on the market, and they are not all the same. Also, the ammunition will have an effect on sound levels, as Hair Trigger noted above. Subsonic ammunition can be very quiet in a good suppressor out of the right host. Both of my cans are hearing safe with subsonic ammo on my M&P pistols.
A good suppressor will add considerable bulk to most handguns, also as noted above. You will have to take that into consideration for a defensive gun. Not horrible in a house, but pretty much impossible to carry. Also, you'll need proper suppressor height sights, and/or an optic. Recreationally, shooting suppressed is a whole lot of fun, especially .22.
You can get a really good suppressor these days for $400-600, plus the $200 tax stamp, so figure $600-800 all in... and a year wait. Mine actually took ~11 months.
Is it worth the expense? From a practical standpoint, probably not. It would be a lot cheaper and easier to have a nice set of electronic ear muffs by the bedside. Would I do it again? Absolutely.
Edit... missed one of your questions...
One of the best resources I found when researching my suppressors was Silencer Shop's video tests. They do a video for most of the suppressors they sell, and most importantly, they do the test the same way for each one... critical for comparative decibel testing. There are also tons of YT videos out there, but most of them are just anecdotal info.