If you have checked them out RS then you will have seen that they are intended for that very purpose ‘to introduce people (especially children) to computers’. The idea was to provide something very basic that could be built upon, the idea being that as people progressed and maybe came up with an idea of their own then they could add stuff to the board quite cheaply. Take for example building a robot or something like that, so you could add stuff to the board that could sense the vertical and horizontal planes (an inclinometer) to keep it stable or sensors for motion, you can add keypads, Wi-Fi, speakers, the list is endless. Many people now use them for small projects so they have gone beyond their original intention and it is now a thriving industry for all sorts of add ons you can buy. There are several similar things on the market but the Raspberry Pi is the original, there are others are like ‘Arduino’ which are very similar. I have used the Arduino board to build a device that moved my camera forward by tiny increments for when I do Macro Photography. Basically with a Raspberry Pi what you are getting is a bare bones computer mother board that you can plug other stuff into, the Arduino is a bit more electronic biased but requires computer code to work.
If the lad is interested in this sort of stuff he will probably love it, a bit like me being given a Chemistry Set as a boy. However there is some learning involved and he will need to gen up on the internet, but there are lots of tutorials out there, to be honest I could not even start to discuss this side of things on here as it will all depends on how he progresses and how involved he becomes with it. What is certain is that if it clicks with him he will no doubt become embroiled in the subject. It will certainly be a “walk before you can run” exercise, so unless he actually has some sort of experience you may (depending upon your proposed outlay) be better off getting something that is a ‘starter kit’ that has the basic stuff and instructions to do certain projects as these will encourage him and keep him interested, basically it is no use having a car if you do not even know how to start it. The kits are like giving him a course of driving lessons, so as he becomes more proficient he will want to do bigger and better projects.
To try and put this in context it would be no use giving him a kit that built a radio receiver if he knew nothing about soldering or electronics, but with the starter kits the items are provided and small projects are included, a bit like a LEGO kit that makes a certain thing, but you can use the individual bits in other stuff later on if you can make it fit together, basically its all in your own imagination.
Can I suggest that you also look at the 'Arduino' boards as a starter option and to look them up on YouTube, this for example is one of their kits.
https://www.amazon.co.uk/Elegoo-Complet ... tarter+kit
This is not the same as a Raspberry PI which is more like a basic computer, but this is like getting a ‘Mechano Set’ with lots of electrical bits and small projects to get you interested. All the stuff is intended to be soldering free and you plug your wires into a special board to make up the circuits you need to control stuff. The projects may appear simple like making a set of coloured LED lights flash in a certain combination or a buzzer working in a certain way and again like the Raspberry Pi they are expandable with all sorts of add ons. Once he learns the basics he can conjure himself up all sorts of projects, here is an example below. I wanted to move my camera forwards at on a few thousands of an inch at a time, this was virtually impossible to do by hand, so I decided to use an Arduino board to control another board that would move the stepper motor that moves the slider mechanism. It involved me playing about with some circuits and learning some programming code to put it together, here you can see some of the stages.
Playing with some circuits
The Arduino on the left is controlling the board on the right which drives the motor, the LED tells me it is working.

Here you can see the stepper motor that I want to drive the slider mechanism forwards and backwards in tiny incriments.
Here it is all built into a box with switches and lights that will flash to indicate what part of the program is running. (the motor is not yet connected)
Here is my camera project when it is running taking Macro images of a fly (if you look closely

).
My best mate who incidentally helped me with the coding also used a similar Arduino to power his garage door up and down, it even does it with an ‘Alexa’ command. Now I am not saying that he has to start with a complex task, this is just to give you some idea of how an Arduino can be put to use, he would use a Raspberry Pi in a similar manner but with a more computer bias. if he likes tinkering and has a computing/electronics bent then he should like any of these.