Fallout 3 was very successful. If selling many copies is the yardstick you measure quality by, it may well have been one of the greatest CRPGs of all time.

By other metrics it may fall a bit lower down the ranks. For example, the writing is quite bad (the water is thoroughly irradiated from a war that happened 200 years ago).