Considering most houseplants naturally come from tropical climates, a lot would love direct sun as they thrive on that in the wild, unless they are understory plants that grow on forest floors.

All sorts of ficus, schefflera, dracaena to name a few.

just so you know, sunlight through a window is filtered by the glass and no where near as stong as it it outside. I wouldn't even consider it direct sunlight.

i acclimate all of my sun loving indoor plants to outdoor direct sun every summer. That's when they put out the best growth.

the only thing you ever need to worry about with sunlight through a window is the plant heating up too much. The slightest bit of air circulation will fix that though.

unfortunately, there's a common misconception that all indoor plants shouldn't be placed in front of a window that receives full sun. It's not true, and plants usually end up not getting enough light due to that.

all of these are in a south facing window that receives sun all day (sun is starting to set in this photo and not as intense) with the addition of grow lights.

L to R: one 7' and two small ficus Benjamina, a dracaena and a schefflera.

Plants good for full, southern, unobstructed, include;

Ficus

cacti

succulents

Bird of Paradise (both the smaller retinae and larger nicolae)

CITRUS

Cattleya orchids

Aechmea bromeliads

Palms (including Chinese fans, Dypsis "Areca Palms", Phoenix roebellini "Pygmy Date")

There are others...,

I have southern exposures in the house..., just keep in mind, the really SUNNY season may, in fact, be the WINTER when the low sun angle gets into the house. Once we get into the Spring and Summer, I actually lose light due to the higher sun angle, deciduous trees (even the lack of any snow!). But that depends of course on where you are and the local climate. Winter this year has been ridiculously sunny and sometimes my summers are fairly overcast.

Wow I wish I had some direct sun...or any sun would be nice. ;-)

Good list by subtropix. I just want to double down on cactus/succulents because those are my favorites.

The OP specifically said that he has cactus and wants plants with foliage

Most plants will do just fine in direct sun, the only problem I have seen is some Dracaenas getting sunburn if moved there with no acclimatisation. D. Lemon limes don't like it, and start getting spotty.

The following all love full sun:

Yucca

Ficus - all types

Schefflera - all types

Crassula

Sansevieria

Nolina/Beaucarnea

Croton

Chamaedorea

Dracaena Marginata

Slight deviation: I love those plant labels that allegedly have care info on them, almost all species say "plenty of light but avoid direct sun".