A streaming device is one that basically streams channels/apps through the internet and there are several brands that make such devices (Roku, Google, Apple, Xumo, etc...) They don't usually record content on their own unless the app/streaming service supports it. Examples include Comcast, Spectrum, DirectTV, which provide Cloud DVR services as part of their cable/sat packages. I have Spectrum TV cable service, for example, but do not use cable boxes and instead stream their service on the Spectrum App with the Roku and use their cloud DVR to record shows just like I normally would with DVR boxes without the cost of renting the DVR boxes from the cable provider. You can fast forward and rewind on cloud dvr similar to a DVR box.
As previously mentioned, you will find it difficult to avoid ads on apps and or devices themselves as they sell these things close to cost and make their money by the ad space they sell and/or subscriptions they sell. Some apps/providers provide a subscription level that cost more to avoid ads, similar to the old days of paying for premium movie channels, like HBO, Cinemax and others. However, free content is only free because it is supported by the ads on those channels. Most free content would not exist if that didn't occur and the few channels that try to do that are most likely pirating content and won't stay around long and/or may have some shady practices or motivation. Not all paid content provides ad-free subscriptions either for the same reasons as the free channel providers.
You said basic Roku device, so I am not exactly sure what you mean as all Roku devices are streaming devices. The different Roku devices have varying capabilities and limitations and the older the device, the more likely it no longer supports the current operating system and/or new channels/apps that are out there. It is better to have a new generation device and the newest 2024 Ultra (as far as Rokus go) is considered the top tier device. Its capabilities are better in my opinion for sure as compared to the cheaper cost Roku stick devices, but that is also dependent on your internet capabilities as well as the quality of TV you are using. It really depends on what your needs are in terms of what you are looking for in a device as the different devices have different capabilities.
I suggest searching and comparing the different Roku devices on their store page as well as look at some of the other brands of streaming devices and compare those and see which will fill the need for what you want. Keep in mind that brands may not have the channels/apps you are looking for, so you should check that as well before purchasing. For example, Spectrum TV is not available on all Google TV devices and some channels/apps are not available on some third-party TVs that use the Roku operating system. I personally suggest being leery of budget level TVs that use the Roku operating system as there seems to be a number of complaints with those TVs.
Hope this information helps.