I have used a Leupold tube style red dot since 2004 on my revolver. Have put minimally 50,000 rounds (.38 target) through that gun without a hiccup using that red dot. Batteries last a long time.
Not sure that it's even made any longer, but Leupold still make them in a smaller simple screen version. Burris makes one very similar as well. Stick with the big names and you likely cannot go wrong.
mike