This is pretty much how I use my decks as well—mainly for self-reflection, meditation, journaling, and working through my thoughts and feelings about different areas of my life. Just to note though, this is all based on my personal experience.
I actually started out with oracle decks, but over time I stopped using them as much. A lot of oracle decks have specific phrases or situations printed on the cards, and I found that sometimes limited how deeply I could interpret them or explore different angles of a situation.
I also tend to avoid Rider–Waite–Smith style decks because I’ve never really connected with the Golden Dawn symbolism behind them. I did start with a traditional RWS deck, but I didn’t really get into tarot until I discovered the Tarot de Marseille (TdM).
You might find TdM interesting, especially since you mentioned liking Lenormand for its straightforward symbols and the freedom to project your own ideas onto them. TdM reading often focuses on how the cards interact with each other to tell a story, rather than relying on fixed meanings for each card. That approach can be really useful when you’re trying to think through a situation from multiple perspectives. If you’re curious about it, you could look up Yoav Ben-Dov and the CBD Marseille deck for more information.
As for other decks, I personally enjoy ones with detailed artwork that sparks emotions or ideas. Some that I like include Hush Tarot, Tarot of the Divine, Oak, Ash & Thorn, White Numen, Wildwood Tarot, and the Illuminated Tarot (which can be interesting if you want to experiment with more cartomancy-style reading).
For self-reflection, I’ve found that the most important thing is simply choosing a deck whose imagery you connect with. Watching walkthroughs or “card flip-through” videos on YouTube can be really helpful for that, since you get to see every card before deciding.
Anyway, good luck with your search! Using cards this way can be a really rewarding practice. I’d be curious to hear which decks or systems you end up connecting with.