I’ve had one for a bit, used a couple more.
They are absolutely brilliant for some things, less so for others.
Generally, I find that if something has dirt on the outside, then unless it’s very intricate, there are better ways to clean it than an ultrasonic cleaner. I certainly don’t think I’d be using it on a handgun frame, or tools. Maybe it would be worth an experiment, provided it’s a stainless or plastic frame?
For things like watch parts, they work superbly well. No way you could clean bits that intricate, that well, that fast. Jewellery, maybe, but most professional jewellers don’t use one for that. For things like pen nibs (especially drawing pen nibs) they are awesome. They shift dried ink better than anything.
As for what type. I’ve got a small / cheap ($20) made in China one. It seems to work just fine, and has done for a few years. You can spend a bit more money (maybe $150) and get bigger / metal bodied, but still made in China, and I doubt much better.
If you spend a lot more you get one of the much better (Swiss) machines that are used in watch servicing. Bigger than mine, much better made, and heated. But way more costly.