A bot uses little, until it does not
A command bot for a small server runs comfortably on 256 MB. What drives RAM up is caching things in memory, playing music or serving hundreds of guilds at once. That is why plans go from 256 MB to 4 GB instead of selling you one generic figure.