We have 14 frosted skylights on our flat-roof house here in the desert southwest US and, as a result, almost never need lights on during the day except in the bedrooms which don’t have the skylights.
Had a friend who tried the Sun Pipes (had peaked roof with enclosed attic, so they were about the only viable choice), but didn’t like them and had leak problems.
One thing with skylights is you need to have them installed correctly and keep them well sealed/caulked or you will get leaks.
The frosted ones help prevent sun damage on carpets, furniture, etc. and are better in keeping the summer heat out, but that is obviously more of an issue here with 300+ days of sunshine per year.