Yes the approaches need to be done in instrument conditions (actual or simulated), and must be flown to minimums. That's really the heart of the matter, anyway...the requirement is for proficiency, and getting and staying proficient isn't likely if you aren't flying it by reference to instruments, and flying it all the way down.
Even where you don't have a safey pilot, however, you're doing the right thing by picking up the approach and flying it anyway. Even though you didn't have a hood, you're still gaining some valueable experience in the proceedure.
What I used to do was fly the approach at every airport I visited, even when coming back VFR. And when flying in mountainous country, I flew the approaches in the day so that I was familiar with them at night, and always flew them at night regardless of the weather, for terrain. When the time came to fly the same approach in instrument conditions, I was already familiar, and a lot more confident being close to the terrain.
By flying them on your own visually, you can correlate what's going on on the panel to what's going on outside, and you can use this information to your benifit when flying an approach in instrument conditions. For legality, you will either need to fly the approach in the cloud or with a safety pilot and a view limiting device...but you can get useful experience either way. If you fly somewhere, try to arrive by flying the approach visual or otherwise. It's always good practice.