I don't regret my purchase, but I'm not sure the Switch is the place to look for story-driven games at the moment... at least ones that aren't JRPGs. There are some, but they're mostly smaller fare and multiplatform. I'd reckon that the platform will eventually become home to a rich visual novel library due to its popularity in Japan... a Phoenix Wright collection and a new entry are supposedly planned for Switch, and the next game from Kotaro Uchikoshi (of 999/Virtue's Last Reward fame) is also Switch-bound. But if you're looking for big-budget cinematic experiences akin to what you find with Playstation's exclusives, you're probably gonna be disappointed.
Switch's biggest titles (Mario Odyssey, Zelda BotW) aren't really story-driven experiences. Currently, the Switch's biggest story-driven exclusive would probably be something like Xenoblade Chronicles 2, which is a JRPG. It's possible that the next Zelda might have a stronger narrative focus, but that could be years away and certainly isn't a guarantee.