Doesn't this mean that using sf::View is a bad idea, since in larger maps a lot of unnecessary stuff will be drawn?
No, it's perfectly fine to work with
sf::View, but as I said, you're resposible for only drawing what's really being displayed. So if you're at the top-left corner of the map, there's no reason for processing the part at the bottom-right corner.
Or are the graphics cards good enough that I shouldn't be worrying about this when making 2D games?
It always depends on the actual size and on the age of the notebooks you want to make your game run on. Newer graphics card will handle quite a big space, where as older one, need more optimization.