I have a lot of experience with red dots (Burris FFII & FFIII, Aimpoint Micro, Matchdot, Ultradot, Bushnell) on revolvers, pistols, and rifles from .22lr to .45 and .308. Shooting for fun as well as Bullseye and Steel Challenge. I have a 617 currently sporting a Matchdot. The previous owner had installed rings for a scope as he shot silhouettes. I kept the mounts and installed the Matchdot in them. Sorry - no picture handy.
First, if you have vision issues, a dot will change your shooting life! I have an astigmatism and both far and near sightedness. My shooting glasses are no-line bifocals. A dot allows you to shoot with both eyes open and focused on the target. For me, this is huge. The target and the dot are both in focus and I don't have to keep lifting my head up and down to find the sweet spot in the bifocals. The only way I can shoot irons accurately is to use my "computer" glasses which make everything beyond about 2 feet blurrier than no glasses at all.
The Burris FFIII is a great sight and a great value. Don't get the FFII as changing the battery requires removing the sight from the gun and you can't adjust the intensity. The only issue with reflex sights is finding the dot in a hurry. The area of the objective lens is small and it takes some practice to get the dot in the view area quickly when getting on target. You will see guys swinging the muzzle around in a circle while looking down the sight. They are "hunting the dot". With some repetition you will find it less of an issue. I use 3 MOA on my Bullseye guns and 8 MOA on my race guns. Once I didn't properly install the screws on a Burris FFIII for my CZ P01 (below). During firing, the sight came off the slide, bounced off my forehead and then landed on the concrete shooting pad. It wasn't damaged and is still in use today (properly installed!).
With a tube such as the Matchdot, hunting the dot is a lot less of an issue. The tube itself assists in lining up the sight and once there the dot is visible but the sight also obscures more of your field of vision than the Burris. The Matchdot has more options on intensity and dot size compared to the Burris. I also have an Ultradot which adds the ability to choose your reticle so you aren't restricted to just a dot. The price is higher than the Burris.
The Aimpoint Micro is a little tank. Solidly built, waterproof, with phenomenal battery life. It has a short tube and good range of variable intensities so has the benefits of the Matchdot in a smaller more durable package. I have one on a Ruger 22/45 Lite for Steel Challenge. The price is very high. The dot costs more than the pistol but it is an awesome combination. It's my wife's favorite range toy too.
The Bushnell TRS 25 is a cheap imitation of the Aimpoint. I have one on a 10/22 style race gun I use in steel. It works but the quality is not great. It might be a good way to start though. There are several rails to choose from that would work and allow you to upgrade the dot to an Aimpoint or Matchdot later. For the Bushnell or Aimpoint, I like the looks of this one from Weigand -
Smith Wesson Revolver Mini Mount. For the Matchdot you would need the longer rail version from Weigand or others.
Allchin is great for the Burris as it keeps the sight low and looks clean. I have an Allchin mounting an FFII on a 686 similar to some of the photos others have posted.
Keep in mind you will have to remove the rear sight no matter what you do. It is possible to go back to irons but it isn't a quick change. You'll be committing to dots in the short term.
So figure out your price range and do it.